topic Hiding/Showing Sheets in QlikView

Hiding/Showing Sheets

Fri, 24 Feb 2012 11:37:40 GMT

For a number of sheets in my model I want to hide the sheets when they are inactive. I have tried the conditional 1=2 for the sheet and can hide them. However I have not been able to get the sheets to open again unless I go into the Document Properties. Ideally I would like to use a button on my main sheet to open and activate some of these hidden sheets. Please can anyone point me in the right direction, regards Maria

Hiding/Showing Sheets

Fri, 24 Feb 2012 12:01:14 GMT

Hi Maria,

check attached example.

Kind regards

Przemek

Hiding/Showing Sheets

Fri, 24 Feb 2012 12:04:13 GMT

Sorry I cannot see the attachment!

Re: Hiding/Showing Sheets

Fri, 24 Feb 2012 12:06:57 GMT

My mistake, sorry.

Re: Hiding/Showing Sheets

Fri, 24 Feb 2012 12:17:13 GMT

Thank you much appedciated

Regards

Maria

Re: Hiding/Showing Sheets

jack — Thu, 21 Dec 2023 14:05:00 GMT

did download the demo, but when adding to my set , can't get de the variable vShow active

what do i wrong???

thanks for advise

Re: Hiding/Showing Sheets

jack — Thu, 21 Dec 2023 14:20:03 GMT

ok thas solved by ctrl alt V

but i have 3 sheets, so if want to toggle from dashbord i did create a vShow2 and vShow3 and added

to variables, then create in dashboard a action like vShow2=0,1,0 and vShow3=0,1,0

that did not work

please advise, thanks

Re: Hiding/Showing Sheets

jack — Thu, 21 Dec 2023 14:22:38 GMT

sorry, solved , had to add them all to project varaibles , then works ok