topic Re: Re: Hiding/Show sheets in QlikView

Hiding/Show sheets

Wed, 26 Nov 2014 04:14:19 GMT

application have two sets of sheets in my application and a main menu sheet, with two buttons in main menu.

by default only this main menu sheet should be visible and all others sheets should be hidden.

when I click on one button its associated sheets should highlight and I should have button to got to main menu in all sheets .

when I click on this go to main menu all sheets should be hidden and main menu sheet should be visible.

kindly help me out. \

Please find the attached qvw.

Thanks in advance.

$@M

Re: Hiding/Show sheets

amit_saini — Wed, 26 Nov 2014 04:19:11 GMT

Check attachments.

Thanks,

Re: Hiding/Show sheets

Wed, 26 Nov 2014 04:27:20 GMT

Hi Amit,

I have multiple sheets for a single set , in that case it will not work.

Re: Hiding/Show sheets

ecolomer — Wed, 26 Nov 2014 04:39:48 GMT

I this you need?

Re: Hiding/Show sheets

amit_saini — Wed, 26 Nov 2014 04:43:44 GMT

Samapth,

The best solution in this cases it to play will variables . Create 2 variable

For example :

vShow =1

vHide=0

and assign these variables to you sheets accordingly. After that create two buttons to Show and Hide all these sheets.

Hope this will help!

Thanks,
AS

Re: Re: Hiding/Show sheets

sasikanth — Wed, 26 Nov 2014 04:50:30 GMT

Hi sampath,

by setting a variable action will resolve your problem,

please find the attached file

Re: Re: Hiding/Show sheets

Anonymous — Wed, 26 Nov 2014 04:58:47 GMT

Hi,

PFA.

Hope it helps.

Thanks,

Nisha loganathan

Re: Hiding/Show sheets

Wed, 26 Nov 2014 05:16:10 GMT

what you have given works for me but there is a small change in it . i.e

when I click on set1 main sheet should be hidden and we should navigate to sheet1 and sheet2 and sheet3 will be active.

like wise for set2 also.

Thanks in advance.

Re: Re: Hiding/Show sheets

Anonymous — Wed, 26 Nov 2014 05:26:20 GMT

PFA updated one.

Thanks,

Nisha loganathan.

Re: Hiding/Show sheets

sasikanth — Wed, 26 Nov 2014 05:40:11 GMT

set another variable and

write in lay out condition of main page like in the qvw file

Re: Re: Hiding/Show sheets

ecolomer — Wed, 26 Nov 2014 05:44:09 GMT

here you have

Re: Hiding/Show sheets

ankit777 — Wed, 26 Nov 2014 06:49:23 GMT

Hi,

Just create one variable. Change the values according to the need.

Like for main sheet $(vSheet)=0

for first set $(vSheet)=1

for second set $(vSheet)=2

just change the values on button click action and give condition for all sheets.