topic Re: Hide Sheets in QlikView

Hide Sheets

Wed, 26 Jun 2013 15:21:10 GMT

Hi All,

I want to hide current sheet when i navigate to different sheet upon activation by using button and vice versa

Please find attachment

Re: Hide Sheets

alexandros17 — Wed, 26 Jun 2013 15:26:31 GMT

Create a variable and set its value to 0, then in the button action (External - variables) set For example:

if(myVar=0,1,0)

in the sheet properties, in conditional set : myVar=1

Hope it helps

Re: Hide Sheets

Miguel_Angel_Baeyens — Wed, 26 Jun 2013 15:30:05 GMT

Hi,

Use an additional action in a variable and set it to conditionally show or hide the entire sheet.

Hope that helps.

Miguel

Re: Hide Sheets

jagan — Wed, 26 Jun 2013 15:33:15 GMT

Hi,

PFA file for solution.

Regards,

jagan.

Re: Hide Sheets

jagan — Wed, 26 Jun 2013 15:36:43 GMT

Hi,

Show Hide sheets implemented in your file.

Regards,

Jagan.

Re: Hide Sheets

Wed, 26 Jun 2013 15:48:37 GMT

Hi Jagan,

when i click on sheet 1 details button to activate new sheet.... i need to close sheet 1 overview

Re: Hide Sheets

jagan — Wed, 26 Jun 2013 15:58:05 GMT

Hi,

PFA file for solution.

Regards,

jagan.