Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Getting list of all sheets

Hi All,

Please find attached screenshot.

Can you please suggest he to get list of all sheets.

thanks,

15 Replies
Colin-Albert

Settings / Document Properties  (Ctrl-Alt-D), select Sheets

At the bottom left of the tables, select export structure.

You can then open the exported file xxx.Sheets.tab in a text editor such as notepad

sheets.JPG.jpg

Golf Quest.Sheets.tab

SheetId Caption Status #Objects

Document\SH01 Intro Visible 8

Document\SH02 Filters Visible 47

Document\SH06 Course Description Visible 33

Document\SH07 Map Visible 10

Document\SH08 Sheet4 Visible 6

ThornOfCrowns
Specialist II
Specialist II

I didn't know that! Thanks, Colin Albert

its_anandrjs

Hi,

Go to Settings -> Document Properties -> Select All sheet id -> and export structure -> and if you want to read this structure make a table in qlikview.

Hope this helps

Thanks & Regards

Colin-Albert

There is also an objects file created when the structure is exported

Golf Quest.Objects.tab

SheetId ObjectId Type Caption ShowMode Layer CalcTime Memory

Document\SH01 Document\TX175 Text Object  Normal -5 0 0

Document\SH01 Document\TX144 Text Object  Normal -5 0 0

Document\SH01 Document\TX154 Text Object  Normal -1 0 0

Document\SH01 Document\TX174 Text Object  Normal -1 0 0

Document\SH01 Document\TX176 Text Object  Normal -1 0 0

Document\SH01 Document\TX177 Text Object  Normal -1 0 0

Document\SH01 Document\TX203 Text Object  Normal -1 0 0

Document\SH01 Document\LB36 List Box =minstring(if(Transkey='Language',$(vLanguage))) Normal 1 0 0

Document\SH02 Document\CH06 Bar Chart =minstring({<Index = {4}>} $(vLanguage)) Normal -2 0 0

Document\SH02 Document\CT02 Container  Normal -2 0 0

Document\SH02 Document\TX33 Text Object  Normal -1 0 0

Document\SH02 Document\TX52 Text Object  Normal -1 0 0

Document\SH02 Document\TX06 Text Object  Normal -1 0 0

Document\SH02 Document\TX27 Text Object  Normal -1 0 0

Document\SH02 Document\TX26 Text Object  Normal -1 0 0

Document\SH02 Document\TX08 Text Object  Normal -1 0 0

its_anandrjs

Hi,

Here you get

Sample.bmp

deepakqlikview_123
Specialist
Specialist
Author

Hello Expert,

I mean to say how to make setting at sheet level to visualize sheets one below the other,please llok at attached screenshot.

Thanks,

rustyfishbones
Master II
Master II

Hi Colin,

I know we can use -prj folders to import xml files etc...

But, can you import the structure of the Sheet Tabs?

Regards

Alan

jsingh71
Partner - Specialist
Partner - Specialist

Hi,

Right click on any toolbar and then select "Sheet" . After that one Dropdown list will display which will show all the sheets available in your QV Application.

Sheet.png

Andrea_Ghirardello

Do you mean using script?

If so, try this

for i = 0 to ActiveDocument.NoOfSheets - 1

    set ss= ActiveDocument.GetSheet(i)

    msgbox(ss.GetProperties.Name)

next

If you mean that you want to see the entire list of sheets in the Document, open the Document properties window and activate the Sheets tab.

At last but not least, if you want to make sheets visible, disable the "Hide tabrow" checkbox in the Document properties window, sheet General