topic Re: Dynamically Showing/Hiding Sheets with Navigation Button in Qlik Sense in App Development

Dynamically Showing/Hiding Sheets with Navigation Button in Qlik Sense

brunov86 — Tue, 20 Feb 2024 22:42:36 GMT

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

Re: Dynamically Showing/Hiding Sheets with Navigation Button in Qlik Sense

AHub2023 — Tue, 20 Feb 2024 23:32:22 GMT

Hi,

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

Thanks,

Dev

Re: Dynamically Showing/Hiding Sheets with Navigation Button in Qlik Sense

LRuCelver — Wed, 21 Feb 2024 07:16:20 GMT

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.

Re: Dynamically Showing/Hiding Sheets with Navigation Button in Qlik Sense

brunov86 — Fri, 23 Feb 2024 13:36:12 GMT

Thanks for your clear explanations.

Works like a charm !

Re: Dynamically Showing/Hiding Sheets with Navigation Button in Qlik Sense

Dipti123 — Wed, 17 Sep 2025 09:33:14 GMT

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!

Re: Dynamically Showing/Hiding Sheets with Navigation Button in Qlik Sense

Adam_Romanowski — Wed, 17 Sep 2025 10:04:58 GMT

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.

Re: Dynamically Showing/Hiding Sheets with Navigation Button in Qlik Sense

Dipti123 — Fri, 19 Sep 2025 07:11:29 GMT

Yes ,it works Thank you @Adam_Romanowski