Skip to content

Instantly share code, notes, and snippets.

@ralfbecher

ralfbecher/QlikView_Read_SheetIDs.qvs

Last active January 25, 2017 16:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ralfbecher/6413085 to your computer and use it in GitHub Desktop.
Save ralfbecher/6413085 to your computer and use it in GitHub Desktop.
Download ZIP
Read sheet ID and name of a QlikView document
Raw
QlikView_Read_SheetIDs.qvs
Set vDocument=C:\Projekte\QlikView\MeineApp.qvw;
Sheets:
LOAD '$(vDocument)' as DocumentName,
SubField(SheetId, '\', 2) as SheetID,
Title as SheetName
FROM [$(vDocument)] (XmlSimple, Table is [DocumentSummary/Sheet]);
@janakiv
Copy link

janakiv commented May 28, 2015

Hi Ralf,

I want to join the table generated from above with table that contains Sheet ID, Document Name and Username (which I am getting from Audit Logs), but since the Audit logs have dashabords which I don't use anymore I am having issues creating one table which consists of the fields
Document name, Sheet ID, Sheet Name, Username and Timestamp.

Can you help me with this?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment