topic Re: Conditionally hide and show the sheets in QlikView

Conditionally hide and show the sheets

Wed, 26 Dec 2012 12:46:20 GMT

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,

regards,

baru

Re: Conditionally hide and show the sheets

Gysbert_Wassenaar — Wed, 26 Dec 2012 12:59:32 GMT

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.

Re: Conditionally hide and show the sheets

Wed, 26 Dec 2012 20:45:59 GMT

Hi Baru..

The hiding and conditional showing of sheets can also be done by using variables, I am attaching sample app you

verify it..

hope it helps you

regards

ramesh

Re: Conditionally hide and show the sheets

er_mohit — Thu, 27 Dec 2012 13:11:38 GMT

using macro code it should be done.....

Re: Conditionally hide and show the sheets

Fri, 04 Jan 2013 11:56:22 GMT

Hi ramesh,

Thanks for reply...now it working fine.

Re: Conditionally hide and show the sheets

Thu, 26 Dec 2013 19:58:47 GMT

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

Re: Conditionally hide and show the sheets

brooksc57 — Tue, 28 Oct 2014 14:37:45 GMT

you have a password on your example.

Re: Conditionally hide and show the sheets

Tue, 28 Oct 2014 14:50:52 GMT

Hi,

Create variables and place it in layout--->show----> conditional

as per your requirement

Re: Conditionally hide and show the sheets

Fri, 27 Feb 2015 16:20:33 GMT

Hi Baru,

Did you figure out how to open this sheet?

Please let me know

There's a password protection on it.

Thanks

Re: Conditionally hide and show the sheets

Fri, 27 Feb 2015 16:27:33 GMT

Hey Ramesh,

There's a password protection on this qvw. Do you mind sharing?

Or remove and share the qvw again.

Thanks

Re: Conditionally hide and show the sheets

Tue, 30 Jun 2015 10:36:45 GMT

Thank You for this.