topic Re: Hide sheets visually in App Development

Hide sheets visually

JSmit — Fri, 17 Mar 2023 14:30:17 GMT

For an App we have a large number of sheets, which makes the app difficult to navigate from the sheets overview.

I would like to hide a number of sheets which are not needed to navigate to directly.

In QLIK we have the option to hide a sheet, but as far as I see this prohibits access instead of only hiding the sheet visually.

My question: Is there a way to hide sheets only visually (or group them together) to reduce the number of sheets that are shown in the sheet overview?

Re: Hide sheets visually

Alan_Slaughter — Fri, 17 Mar 2023 14:54:57 GMT

Hi JSmit, maybe this would be helpful:
https://community.qlik.com/t5/Official-Support-Articles/How-to-restrict-hide-or-unhide-sheets-in-Qlik-Sense-Enterprise/ta-p/1713916

https://community.qlik.com/t5/New-to-Qlik-Sense/easily-hide-a-sheet-in-Qlik-Sense/td-p/1777884

Re: Hide sheets visually

Vegar — Fri, 17 Mar 2023 23:58:52 GMT

I haven't tried this myself, but what if you create a show condition that is only valid when you navigate to your sheet (by navigation buttons of some kind), and invalid when navigating from the sheet?

If your in Qlik SaaS or Qlik Sense February 2023 then you could try using objectid() to control you show condition.

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/SystemFunctions/ObjectId.htm

Re: Hide sheets visually

rpennacchi — Tue, 21 Mar 2023 00:16:57 GMT

Hi, JSmit,

I will share a qvf that can do what you want.

Basiclly, when you click on the button, it changes the variable value and redirect for a specific sheet. The variable value makes the "show condition" of the sheet true, so the sheet is visible. When you click on the back button, it changes the value to 'None' and the sheet is hiden again.