Qlik App Sheet Level Show/Hide feature

[Chalorme]

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

[PadmaPriya]

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

Thanks,

Padma Priya

[Bill_Britt]

Hi,

Take a look at this.

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

[Chalorme · Accepted solution]

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!!