topic How to hide required tabs in the dashboard in QlikView

How to hide required tabs in the dashboard

rkpatelqlikview — Wed, 15 Aug 2018 11:27:36 GMT

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.

Re: How to hide required tabs in the dashboard

Gysbert_Wassenaar — Wed, 15 Aug 2018 11:51:26 GMT

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

Re: How to hide required tabs in the dashboard

Anonymous — Wed, 15 Aug 2018 11:54:12 GMT

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

Re: How to hide required tabs in the dashboard

rkpatelqlikview — Wed, 15 Aug 2018 11:54:59 GMT

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

Re: How to hide required tabs in the dashboard

rkpatelqlikview — Wed, 15 Aug 2018 14:18:39 GMT

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?

Re: How to hide required tabs in the dashboard

Anonymous — Thu, 16 Aug 2018 07:23:15 GMT

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

Re: How to hide required tabs in the dashboard

rkpatelqlikview — Sat, 18 Aug 2018 03:01:50 GMT

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.

Re: How to hide required tabs in the dashboard

Arthur_Fong — Sat, 18 Aug 2018 04:16:03 GMT

Hi Kumar,

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

Thanks and regards,

Arthur Fong

Re: How to hide required tabs in the dashboard

rkpatelqlikview — Sun, 19 Aug 2018 03:22:23 GMT

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.

Re: How to hide required tabs in the dashboard

Arthur_Fong — Mon, 20 Aug 2018 08:26:47 GMT

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.

Re: How to hide required tabs in the dashboard

rkpatelqlikview — Tue, 21 Aug 2018 05:45:54 GMT

Hi Arthur,

Thanks for your help.

Yes. It's almost reached to my requirement.

Can we give apply this show and hide concept to the tabs? Suppose If i click on the tab Main2, then that Main2Sheet21and Main2Sheet2 should be hide.

Earlier when we are clicking on the Main2 Text object then the tabs are hidden.

Thanks in advance.

Re: How to hide required tabs in the dashboard

Arthur_Fong — Tue, 21 Aug 2018 06:17:55 GMT

Hi Kumar,

Refer to the attached is the requirement you want.

When Main1 is clicked, Main2Sheet1 and Main2Sheet2 will appear.

When Main2 is clicked, Main2Sheet1 and Main2Sheet2 will be hidden.

Thanks and regards,

Arthur Fong

Re: How to hide required tabs in the dashboard

rkpatelqlikview — Tue, 21 Aug 2018 09:12:19 GMT

Thanks Arthur,

This one i want see in the dashboard.

Thanks again for your help.