Hide objects

[sonysree88]

Hi,

I have 10 sheets in my application, i want to conditionally hide and show 4 sheets in this application.I want to create a buttons in these 4 sheets i will click on one button it will display that sheet and remaining 3 sheets should be hide.

it is possible in qlikview, Can anyone know the solution for this...

thanks in advance,

[sunny_talwar]

Yes hiding and showing sheets based on button clicks is possible with QlikView. You can set hide/show condition on the general tab of sheet properties

[saimahasan]

Yes you can do it.. Go to conditional option in Layout tab and use the variables as 1 to show and 0 to hide.

On the click of the buttons set the variable value as 1 under Actions tab and set Activate Sheet value as the SheetID of the sheet you want to activate.

[t_moutault]

Hi,

try this :

first step : create variable vHideSheet1

second step : on the sheet properties, select show sheet conditionnal : vHideSheet1=1

third step : create button (on another sheet !) like this

hope this help.

[migueldelval]

Hi Sonytgot,

First you need to create a variable (eg: vShow=0)

Second, make a button and in action add--external--set variable--variable: vShow -- Value: 1

Third: In each sheet put this expression: =IF(vShow=1, 1, 0)

If yopu want to make other conditional only you need to change de expression   (eg:=IF(vShow=, 1, 0))

Regards

Miguel del Valle

[sonysree88]

Hi Thomas,

Its really great help to me..Thank you ..

Its working fine but its hidden,Again if want to show that object how can we get back that sheet..Please let me know ..

[sonysree88]

If i want to rollback that hidden sheet how can we do,

Can you any one please help me out with procedure.

[t_moutault · Accepted solution]

you have to go to : settings->document properties-> sheets

that's why the button needs to be in another sheet ! (clik to hide or show the sheet)

[t_moutault]

clik to hide or show the sheet

[sonysree88]

Its cleared now..Thanks for your time