topic Re: Getting list of all sheets in QlikView

Getting list of all sheets

deepakqlikview_123 — Fri, 21 Mar 2014 09:55:50 GMT

Hi All,

Please find attached screenshot.

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

thanks,

Re: Getting list of all sheets

Colin-Albert — Fri, 21 Mar 2014 10:04:48 GMT

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

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

Re: Getting list of all sheets

ThornOfCrowns — Fri, 21 Mar 2014 10:09:48 GMT

I didn't know that! Thanks, Colin Albert

Re: Getting list of all sheets

its_anandrjs — Fri, 21 Mar 2014 10:10:41 GMT

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

Re: Getting list of all sheets

Colin-Albert — Fri, 21 Mar 2014 10:12:30 GMT

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

Re: Getting list of all sheets

its_anandrjs — Fri, 21 Mar 2014 10:14:57 GMT

Hi,

Here you get

Re: Getting list of all sheets

deepakqlikview_123 — Fri, 21 Mar 2014 10:17:23 GMT

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,

Re: Getting list of all sheets

rustyfishbones — Fri, 21 Mar 2014 10:19:55 GMT

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

Re: Getting list of all sheets

jsingh71 — Fri, 21 Mar 2014 10:22:55 GMT

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.

Re: Getting list of all sheets

Andrea_Ghirardello — Fri, 21 Mar 2014 10:30:19 GMT

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)

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

Re: Getting list of all sheets

deepakqlikview_123 — Fri, 21 Mar 2014 10:33:23 GMT

Thanks,

How to hide main sheet1 after getting dropdown list for sheet in above screenshot

Re: Getting list of all sheets

its_anandrjs — Fri, 21 Mar 2014 10:38:40 GMT

Hi,

You can use variables for hide the sheets Like in Go to sheet properties -> Show sheet -> Conditional -> type variable name here and change this variable value from 0 to 1 in front end by input box. 0 for hide 1 for unhide.

Hope this helps

Thanks & Regards

Re: Getting list of all sheets

jsingh71 — Fri, 21 Mar 2014 10:39:29 GMT

GO to Documents Setting and select Hide row.

Re: Getting list of all sheets

Fri, 21 Mar 2014 10:40:40 GMT

You mean you want to hide the tab names "Main" and "Sheet1"?

If so, then you can go to Settings--Document Properties--General tab and on the right hand side among many check box options, you will have one option as "Hide Tabrow". Check that and the tab lables will be hidden.

Hope this helps!

Re: Getting list of all sheets

Colin-Albert — Fri, 21 Mar 2014 10:43:43 GMT

You can also use buttons or text boxes with actions that will naviaget users to a specific sheet or to the next / previous sheet.

Re: Re: Getting list of all sheets

CELAMBARASAN — Fri, 21 Mar 2014 11:16:00 GMT

Hi,

I didn't know for what purpose your requirement.

I have done a sample with the help of triggers, dynamic update.

Attached QVW.