How to hide required tabs in the dashboard

[rkpatelqlikview]

Dear Qlik,

Here the requirement is i have 15 sheets in the dashboard. 10 sheets is belongs to one dashboard and 2 sheets belongs one dashboard and remaining one more dashboard.

When am clicking on "hide tabrow" all the tab are hiding. I don't want to hide all the tabs. I want to hide 14 sheets and 1 sheet need to be displayed. the same way for remaining dashboards.

Please advice if there is a another option where we can hide required sheets.

Thanks in advance.

[Gysbert_Wassenaar]

How is the user going to navigate between sheets if there's only one sheet visible?

[Anonymous]

you may use variables for each Dashboard and define Show Sheet (Sheet properties)

conditional vDashboard1 = 1 for showing, etc. (define vDashboard1 to 0 e.g. in document Triggers)

so you may hide the 14 Sheets and only Show 1 sheet

whenever you Need to Show the 14 other Sheets you Need to deine vDashboard1 to 1

same to other dashboards

[rkpatelqlikview]

Those hidden  sheets are hyper links. The main sheets having the hyperlink to display the required sheets.

[rkpatelqlikview]

Thanks for your solution Rudolf,

We tried to do this but little confusion while doing this one. (define vDashboard1 to 0 e.g. in document Triggers).

Can you please provide the more clarity?

[Anonymous]

Hi Kumar,

you may use a document triggers e.g. on open, define an Action extern, define variable and then define

vDashboard1 set to 0

Only one sheet should be shown. if you want the other 14 Sheets to appear you may use a button and deinfe an Action with vDashboard set to 1

But as Gysbert mentioned, how do you want to Show Dashboard 2 or 3? How do you want to Control the appearance or hiding of Sheets. Doing this with variables is quit easy as I do this very often.

but you Need to know when and how the Sheets must be controlled

If you give more Information I may assist you

[rkpatelqlikview]

Dear Rudolf,

Thanks for your help. I tried  as per you suggestion. Please find the attached file. Here my dashboard should be Main1 and Main2.

I want to see the two sheets.i.e.,Main1 (hyperlinks are Main1Value1, Main1Value2, Main2Value3. These 3 sheets are under Main1 and i want to hide.) and Main2  the ((hyperlinks are Main2Value2, Main2Value2. These 2 sheets are under Main2 and i want to hide.)

When i creating the variable for hiding sheets ,working perfectly but hyperlinks are not worked.

Please advice. Thanks again.

[Arthur_Fong]

Hi Kumar,

Refer attached and the behavior you requested is fixed on Main1/SubSheet1.

Thanks and regards,

Arthur Fong

[rkpatelqlikview]

Thanks Arthur,

Excellent. It's working fine.

When i clicked on Main2, then only that current sheet is hiding. Is there any chance to hide that current sheet when am clicking on the Main1/Main2 tabs. Instead of clicking Main1/Main2 Button.

Thanks again for your help.

[Arthur_Fong]

Hi Kumar,

Not really understand your requirements, but you can refer to the attached below.

When Main2 is clicked, Main1Sheet1 and Main1Sheet2 will be hidden.

Do play around and see if this covers your requirements.