topic Re: How to hide sheets and activate them when tab pressed in QlikView

How to hide sheets and activate them when tab pressed

Wed, 18 Nov 2015 20:25:54 GMT

I am working on a report and created 4 more sheets to our existing Analytics setup. I also incorporated the sub tabs that were created for our analytics. My question is how do I hide the extra sheets, but when I click on the tab the correct sheet gets activated? (See Screenshot tabs). I saw in the sheet properties that the show sheet is set to conditional and there is a variable setup. I created my own variable in the script and then adjusted each sheet accordingly. However, when I set the sheet to be conditional, the tabs disappear from the view and I can see that the sheets have a status of Conditional: Hidden.

Any help would be appreciated.

Re: How to hide sheets and activate them when tab pressed

varunreddy — Wed, 18 Nov 2015 20:34:07 GMT

Use layout condition for the sheet and use the variable for the button. This will help you showing only selected tab.

Regards,

Varun Reddy

Re: How to hide sheets and activate them when tab pressed

Wed, 18 Nov 2015 20:39:35 GMT

Thank you for the response. I did try that and the tab disappeared from view. See attached screen shots

Re: How to hide sheets and activate them when tab pressed

varunreddy — Wed, 18 Nov 2015 20:47:40 GMT

Use Button Object to select that Sheet

Let me know, if you have any questions

Regards,

Varun

Re: How to hide sheets and activate them when tab pressed

varunreddy — Wed, 18 Nov 2015 21:04:33 GMT

Brian,

Please find the sample in the below link

Test.qvw

Hope this helps.

Still have doubts, follow this link

SHEETS HIDE AND SHOW

Regards,

Varun

Re: How to hide sheets and activate them when tab pressed

Wed, 18 Nov 2015 21:41:19 GMT

thank you I got it to work