Show and hide sheets

[arethaking]

Hi All,

I have 3 sheets with Sheet1,Sheet2,Sheet3.

My requirement is Sheet1 is always should be active.

remaining should be shown based on selection.

If Sheet2 is active, sheet3 should be hidden.

If Sheet3 is active, sheet2 should be hidden.

Please advise.

[punitpopli]

You can save the QVW on sheet 1 or can apply Activate sheet on OnOpen trigger followed by the sheet ID

[Anonymous]

Hi,

Check out this ..

[arethaking]

Hi Frank Hartmann and Sasi V Kandragula

When Sheet1 is open, Sheet2 and Sheet3 should be hidden.

When Sheet2 is open, Sheet1 should be open and Sheet3 should be hidden.

When Sheet3 is open, Sheet1 should be open and Sheet2 should be hidden.

[Frank_Hartmann · Accepted solution]

like this?

[jyothish8807]

Try this:

[vardhancse]

Hi,

As per your requirement done the changes.

we can use Variables

[beck_bakytbek]

Hi Aretha,

check this: Qlikview Tips & Tricks: How to make hidden tab-row dynamically? - YouTube

i hope that helps

beck