topic Re: Activating multiple sheets in QlikView

Activating multiple sheets

Anonymous — Tue, 19 Dec 2017 16:45:04 GMT

I have the following document. When I select the 'Hello' text box in sheet1 I want it to show me only the the 'main' and 'sheet2' tabs. Sheet 3 shouldnt be show. Likewise I need it to be able to toggle back to show everything.

Many thanks for the help

Re: Activating multiple sheets

maxgro — Tue, 19 Dec 2017 17:12:34 GMT

Add a variable.

Set / reset the variable when you click on the HELLO text

Remove the sheet triggers

In General tab of the sheet use the conditional show and the variable to show/hide the sheet

Look a t the attachment

Re: Activating multiple sheets

Anonymous — Wed, 20 Dec 2017 09:15:09 GMT

Thanks that works well. What if however I had many different tabs which I were to show / hide navigate via a main page ? Would this still be the best method to use or is there a better method ?

Re: Activating multiple sheets

Anonymous — Wed, 20 Dec 2017 10:34:14 GMT

Hi I have attached an updated file which should make it a lot clearer in terms of what im trying to do.

Basically the only the 'main sheet' should display when you initially open the file. Clicking on any of the text boxes should take you to the respective tabs hiding out others.

For instance

- if I click on the Australia text box in the main sheet it should display only the Australia tabs with the landing page being AustraliaSheet1.

- If I click on the USA text box in the main sheet it should display only the USA tabs with the landing page being USASheet1.

If I click on the Europe text box in the main sheet it should display only the Europe tabs with the landing page being EuropeSheet1.

Thanks

Re: Activating multiple sheets

maxgro — Wed, 20 Dec 2017 17:21:32 GMT

in the attachment

Re: Activating multiple sheets

Anonymous — Thu, 21 Dec 2017 09:54:52 GMT

Thanks, I managed to do this also. One thing which Im having issues with is the back button. ( I understand the back button doesn't work so well when working with variables). Basically I want to be able to go back at any point using a single click.

Re: Activating multiple sheets

maxgro — Thu, 21 Dec 2017 17:53:08 GMT

I added a Home text to go back to the home (main) page.

In my attachment it seems the back button works, when I click it I go back to main sheet.