Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
brunov86
Contributor II
Contributor II

Dynamically Showing/Hiding Sheets with Navigation Button in Qlik Sense

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

Labels (1)
1 Solution

Accepted Solutions
LRuCelver
Partner - Creator
Partner - Creator

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:
    LRuCelver_0-1708499621214.pngLRuCelver_1-1708499656413.png
  • Sheet 2:
    LRuCelver_2-1708499690431.pngLRuCelver_3-1708499701773.png

     

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

View solution in original post

3 Replies
AHub2023
Contributor
Contributor

Hi,

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

Thanks,

Dev 

LRuCelver
Partner - Creator
Partner - Creator

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:
    LRuCelver_0-1708499621214.pngLRuCelver_1-1708499656413.png
  • Sheet 2:
    LRuCelver_2-1708499690431.pngLRuCelver_3-1708499701773.png

     

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

brunov86
Contributor II
Contributor II
Author

Thanks for your clear explanations.

Works like a charm !