Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
rkpatelqlikview
Creator III
Creator III

How to hide required tabs in the dashboard

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.

1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

12 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Anonymous
Not applicable

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
Creator III
Creator III
Author

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

rkpatelqlikview
Creator III
Creator III
Author

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
Not applicable

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
Creator III
Creator III
Author

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
Partner - Specialist III
Partner - Specialist III

Hi Kumar,

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

Thanks and regards,

Arthur Fong

rkpatelqlikview
Creator III
Creator III
Author

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.Capture11111.PNG

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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.