topic Re: sheet level access in Management & Governance

sheet level access

bhaskar — Wed, 29 Nov 2023 12:01:39 GMT

Hi,

I'm New to the QlikSense.

searched so many articles in community but little confusion about sheet level access.

how to create sheet level security for one user in QMC.

Example :

Product App has 3 sheets.

sheet 1 , sheet 2 , sheet 3

My query is Product App one user (XXXX) has to access 3 sheets and all users has to access only sheet 1 :

Please guide me step by steps.

Thanks in Advance.

Bhaskar

Re: sheet level access

Or — Wed, 29 Nov 2023 12:25:39 GMT

https://community.qlik.com/t5/Qlik-Sense-Documents/Dynamic-Sheet-Exception/ta-p/1479964

Re: sheet level access

panosalexand — Wed, 29 Nov 2023 13:16:12 GMT

Hi Bhaskar,
Try to load through the script the following variable:
SET vQlikDevAccessUserList = "Match(Right(OSUser(),len(OSUser())-len(SubField(OSUser(),'\'))-1),'XXXX')";

Then navigate to the sheet Actions and select Action= 'set variable value'. In Variable fill in with
=$(vQlikDevAccessUserList).

I hope will work.
Thanks,
Panos