How to hide sheets and activate them when tab pressed

[#1]

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.

[varunreddy]

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

Regards,

Varun Reddy

[#3]

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

[varunreddy · Accepted solution]

Use Button Object to select that Sheet

Let me know, if you have any questions

Regards,

Varun

[varunreddy]

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

[#6]

thank you I got it to work