topic Re: List All Sheets Within a QVW file in QlikView

List All Sheets Within a QVW file

Wed, 09 Oct 2013 23:20:26 GMT

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?

Re: List All Sheets Within a QVW file

nagaiank — Thu, 10 Oct 2013 00:49:58 GMT

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.

Re: List All Sheets Within a QVW file

Thu, 10 Oct 2013 02:22:22 GMT

see that post

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

Re: List All Sheets Within a QVW file

Alexander_Thor — Thu, 10 Oct 2013 03:02:24 GMT

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.

Re: List All Sheets Within a QVW file

saumyashah90 — Thu, 10 Oct 2013 04:30:31 GMT

check this out