topic Sheet Conditions in QlikSense in App Development

Sheet Conditions in QlikSense

amweiner — Tue, 28 Sep 2021 17:46:44 GMT

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.

Re: Sheet Conditions in QlikSense

abhijitnalekar — Wed, 29 Sep 2021 08:27:28 GMT

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

Re: Sheet Conditions in QlikSense

amweiner — Wed, 29 Sep 2021 15:09:44 GMT

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.

Re: Sheet Conditions in QlikSense

amweiner — Wed, 06 Oct 2021 14:55:21 GMT

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".