topic Re: Qlik App Sheet Level Show/Hide feature in QlikView

Qlik App Sheet Level Show/Hide feature

Chalorme — Thu, 12 Jan 2023 08:32:30 GMT

Hi,

Is there any way to show/hide any app's any particular sheet based on user id's in Qliksense? -need to do this without using any security rule change in QMC.

Thanks a lot.

-Chalorme

#qliksense

Re: Qlik App Sheet Level Show/Hide feature

PadmaPriya — Thu, 12 Jan 2023 09:30:47 GMT

Hi @Chalorme

It is not possible without making changes in the security rule. For more reference please follow below article:

https://community.qlik.com/t5/Qlik-Sense-Documents/Dynamic-Sheet-Exception-With-Stream-and-App-Level-Security/ta-p/1482142#.XK3m51iZDB4

Thanks,

Padma Priya

Re: Qlik App Sheet Level Show/Hide feature

Bill_Britt — Thu, 12 Jan 2023 13:52:28 GMT

Hi,

Take a look at this.

https://www.youtube.com/watch?v=1DWu2wd8fhk

Re: Qlik App Sheet Level Show/Hide feature

Chalorme — Wed, 18 Jan 2023 12:19:25 GMT

I got one simple expression level show/hide condition for each sheet , you can put it in Show condition field of the sheet :
MaxString({$<YOUR ID COLUMN={$(=RIGHT(OSUser(),NO OF DIGITS OF YOUR ID NO.))}>}YOUR ID COLUMN) LIKE 'PUT YOUR ID TO BE MATCHED'
or MaxString({$<YOUR ID COLUMN={$(=RIGHT(OSUser(),NO OF DIGITS OF YOUR ID NO.))}>}YOUR ID COLUMN) LIKE 'PUT YOUR ID TO BE MATCHED'

This has worked for me, you can modify the above expression according to your requirement. Please give it a try and do reply if it's useful for you. 🙌

Cheers!!