topic Re: Hide Sheets and open them on button click in QlikView

Hide Sheets and open them on button click

Mon, 06 May 2013 20:21:39 GMT

How can i hide certain sheets and when i click on a button i want to display that sheet. Also when I click on a different button i want to hide the sheet that was just displayed and open the sheet that the button is connected too? Sorry I am new to Qlikview.

Re: Hide Sheets and open them on button click

Mon, 06 May 2013 20:45:59 GMT

This is actually pretty easy!

First, you want to turn off Tabs. Go to Settings, Document Properties, General, and click 'Hide Tabrow'.

Next, you want to create the buttons that will allow you to switch between tabs.

Simply create a button or text object, go to Actions, click Add Action, select type Layout, and pick "Activate Sheet".

Then you just type in the Sheet ID that you want the button to switch you to, and you're all set.

Consider googling the question before you ask it, though - a quick google search turned up a bunch of very similar results to this when I searched 'qlikview hide tab'.

Re: Hide Sheets and open them on button click

Mon, 06 May 2013 20:46:04 GMT

Create a variable vhidesheet and set it to 1. On the Sheet Properties->General Tab, set conditional and assign the variable vhidesheet. Create a button and add action External->Set Variable. Pick variable vhidesheet. In the value field, type the expression =If(vhidesheet = 1, 0,1) that will hide or display the sheet.

Re: Hide Sheets and open them on button click

Mon, 06 May 2013 20:48:31 GMT

Oh, that'd work too. That would be better if cbrune wanted to let users pick between several different sheets at a time (that changed based on clicks), instead of navigating from sheet to sheet via button clicks.

Re: Hide Sheets and open them on button click

Fri, 19 Jun 2015 15:02:55 GMT

Thank you Shivanand.