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 !

[Dipti123]

Hi all,

In one of my Qlik Sense apps, I accidentally added a Show Condition expression at the sheet level:

=$(vshowhide) != null

Because of this, the sheet is now completely hidden in the Hub, and I cannot access it to remove the expression.

• Is there a way to make the sheet visible again?

• Can I remove or reset the Show Condition using QMC → App objects?

• If yes, how do I identify the correct sheet object in QMC and clear the expression?

Any step-by-step guidance would be greatly appreciated 🙏

Thanks!

[Adam_Romanowski]

If it's published app and the sheet is public, you can duplicate the application, open it, switch to sheet edit mode and hidden sheet will be visible in sheets menu.

If it isn't published, just switch to edit mode.

[Dipti123]

Yes ,it works Thank you @Adam_Romanowski