Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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)
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
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.
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.
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
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 ..
If i want to rollback that hidden sheet how can we do,
Can you any one please help me out with procedure.
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)
clik to hide or show the sheet
Its cleared now..Thanks for your time