Dynamically Showing/Hiding Sheets with Navigation Button in Qlik Sense

[brunov86]

Hello,

I'm encountering an issue with implementing a hide-and-display mechanism between two sheets in Qlik Sense.

Sheet 1: Default visible sheet.
Sheet 2: Similar to Sheet 1 but with a different year dimension. I want this sheet hidden by default to prevent user confusion due to duplicate pages upon opening the app.

Objective: Automatically hide Sheet 2 initially. When a user clicks the "Local Year" button on Sheet 1, it should navigate to Sheet 2, and Sheet 2 should be hidden again once the user navigates away.

Setup:

Created a variable vShow with the initial value set to 0.
For Sheet 2, I used the conditional show formula =vShow=1.
On Sheet 1, the "Local Year" button has an action set before navigating with VariableName = vShow and Value = if(vShow=0,1,0).

Issue: Despite these settings, when I click the "Local Year" button on Sheet 1, I receive a message "The content of this sheet is hidden by a condition," and I cannot access Sheet 2.

Has anyone faced a similar issue or can provide insight into what might be going wrong?

Thank you!

#QlikSenseBusiness

[AHub2023]

Hi,

Have you verified , vShow variable changes to 1/0 on button click? 

Thanks,

Dev 

[LRuCelver · Accepted solution]

To ensure always the same sheet is shown by default, initialize the variable in the load script:

Let vShowSheet = 1;

Set up 2 Sheets with a button and a show condition:

• Sheet 1:
  
• Sheet 2:
  

Make sure the correct sheets are referenced in the Navigation section.

[brunov86]

Thanks for your clear explanations.

Works like a charm !