How to get UserIDs for all the users in Qlik Cloud for Sheet level access

[prasuntiwarimmc]

Hi All,

I have a requirement for setting sheet level access in Qlik Cloud. For this I've used the OSUser() function for fetching the User ID and then I've used this in the Show Condition in my sheet. The issue is, How do I get the UserIDs for all the users? Or is there a better way to do this in Qlik Cloud?

[Or · Accepted solution]

There's no such thing as "Sheet level access"... do not confuse show/hide conditions with security. They are not the same thing.

You can look at using GetUserAttr() instead of OSUser(), in particular the Groups option.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/SystemFunction...