Sheet Conditions in QlikSense

[amweiner]

I recently upgraded to QlikSense August 2021 release and am using the conditional sheet feature, but not having much luck. I set up a variable in my load script called vShowPage. I set it 1 if I want to see the sheets, and 0 if I want to hide them. I set the sheet condition expression to vShowPage=1, to see the sheets when the variable is set to 1. I reset the variable several times toggling between 0 and 1 reloading each time, but when I open my app in my workstream, sometimes the sheets are visible, and sometimes not. I have even seen them as visible, then click the thumbnail, and the sheet disappears.

Question 1: How can I hide/show sheets using a variable?

Question 2: Is there a "back door" to seeing hidden sheets in QlikSense? There was a way to do that in QlikView.

[abhijitnalekar]

Hi @amweiner,

1. Is there any flag or user on which you are hiding the sheet.

2. Unfortunately, there is no back door like Qlikview to see hidden sheets

[amweiner]

I set a variable in the load script to determine whether to hide or show the pages. It would be set for all users. Sometimes it works and sometimes it doesn’t. I think there is a defect.

[amweiner · Accepted solution]

I discovered the issue. When specifying the show/hide condition, you must include an "=" sign to the left of the conditional expression, i.e. "=$(vShowPage)=0", instead of "$(vShowPage)=0".