Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to generate a list of all the sheets (sheet names & id's) within a QVW file without typing them individually in an inline load or into a text box?
Hi Amy,
This is a solution that won't require you to use prj folders or macros. You would need to be on QV11 for it to work or the last SR of QV10.
Sheets:
LOAD
filepath() as FileName,
SheetId as SheetId,
Title as Label
FROM [YourAppName.QVW] (XmlSimple, Table is [DocumentSummary/Sheet]);
Replace YourAppName.QVW with the name of your QVW.
If you want to be super fancy you could wrap this in a loop that reads your entire deployment and voila you have a list of all the sheets for all your apps.
To get the sheet id's, you can read the 'QlikviewProject.xml' in the <appl>-prj folder
E.g.
PrjSheetProperties:
LOAD SheetId,
IsActive
FROM [test-prj\QlikViewProject.xml] (XmlSimple, Table is [PrjQlikViewProject/SHEETS/PrjSheetProperties]);
You can get sheet names, from the <sheetid>.xml files.
Hope this helps.
see that post
Hi Amy,
This is a solution that won't require you to use prj folders or macros. You would need to be on QV11 for it to work or the last SR of QV10.
Sheets:
LOAD
filepath() as FileName,
SheetId as SheetId,
Title as Label
FROM [YourAppName.QVW] (XmlSimple, Table is [DocumentSummary/Sheet]);
Replace YourAppName.QVW with the name of your QVW.
If you want to be super fancy you could wrap this in a loop that reads your entire deployment and voila you have a list of all the sheets for all your apps.
check this out