List All Sheets Within a QVW file

[#1]

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?

[nagaiank]

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.

[#3]

see that post

http://community.qlik.com/message/23358#23358

[Alexander_Thor · Accepted solution]

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.

[saumyashah90]

check this out