topic Hide and Un hide Sheets with selection. in QlikView

Hide and Un hide Sheets with selection.

Tue, 17 Mar 2015 07:52:02 GMT

Hi All,

I have straight table i want to open a new sheet when i click on the item.

When i click on specific item i need to open new tab according selection.

Thanks & Regards

Re: Hide and Un hide Sheets with selection.

Tue, 17 Mar 2015 09:53:16 GMT

Hi,

Try to check attached file

Re: Hide and Un hide Sheets with selection.

Roop — Tue, 17 Mar 2015 10:08:34 GMT

Under Sheet Properties:

Check the conditional radio button and add the code:

vHiddenMain = 'N'

Create a variable called vHiddenMain

Create a button with "Unhide":

Set variable vHiddenMain to 'N'

Create a button with "Hide":

Set variable vHiddenMain to 'Y'

See attached

Re: Hide and Un hide Sheets with selection.

mukesh24 — Tue, 17 Mar 2015 10:15:21 GMT

Hi Vamsi,

create field event trigger as -->

In Setting Tab --> Document Properties --> Trigger --> Field Event Triggers(Select Item Field) --> On Select Add Action as Activate sheet --> Give Sheet ID

Re: Hide and Un hide Sheets with selection.

Anonymous — Tue, 17 Mar 2015 10:25:44 GMT

Hi Vamsi,

Need more details -

1. Do you want to select the 'Car' and open a new tab and at the same time want to hide 'main' tab according to yur selection ?

ex. if you select 'Audi' then sheet should be visible with Audi details if you select 'BMW' then other Sheet should be open ?

BKC