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...
On the General tab of the properties screen of the sheet you can select Conditional under Show Sheet. There you can enter an expression that returns true or false to show or hide the sheet. You can use a variable for this for example. Create a variable vShowSheet1 and set its value to 1. Then use $(vShowSheet1) as conditional display expression for the sheet. Next create a button and add an Set Variable action to it. Use vShowSheet1 as variable and =not vShowSheet1 as value. If you click the button then the sheet will hide. If you click the button again the sheet will show again. You can add more variables and more actions to show/hide the other sheets.
One thing that I ran into was that I couldn't hide my sheets, even though I had all the settings and variables set up correctly. I had "Show All Sheets and Objects" selected in the Document properties.
Be sure to turn this off.
Settings | Document Properties | Security | Show All Sheets and Objects
