topic Re: Hide a sheet in QlikView

Hide a sheet

danialier — Tue, 14 Jan 2014 10:50:46 GMT

Hello !

Do you know how I can hide a sheet and make it appear when I click on a text box (located in another sheet) ?

thanks !

dani

vikasmahajan — Tue, 14 Jan 2014 10:55:28 GMT

Approach is Take Variable or if you have section access load variable with excel and apply condition as per attached jpg.

Vikas

Tue, 14 Jan 2014 10:58:00 GMT

Hello Dani, you have to use a variable.

Declare it in Variable Editor, then use in a sheet a Visibility Condition on that variable, finally manage the variable on text field click.

See attached file for a sample.

Regards,

bruno_m_santos — Tue, 14 Jan 2014 10:58:07 GMT

Few steps:

1) Create a variable

Set vShow=0;

2) Then ShhetProperties> General>Conditional, put vShow=1:

3) Create a button, with a trigger >External> Set Variable:

Set Variable "vShow"

value: if(vShow=1, 0,1)

Thanks

Bruno

richard — Tue, 14 Jan 2014 11:06:03 GMT

Sheet B (not to be hidden)

1. Create textbox

2. Create a variable for example called vHideSheetA

3. Go to the actions tab in de textbox properties and add the action type "External" and add the action "Set variable".

4. Fill in the variable name "vHideSheetA" with value 1

Sheet A ( to be hidden)

1. Select the sheet properties

2. Go the the "show sheet part"

3. Fill in this expression example:

vHideSheetA = 0

!!!! Don't forget to make a textbox to show the sheet back! ==> vHideSheetA = 0