Sheet level access

[broddoy]

Hi,

I'm quite new to Qlik Sense (SaaS) and trying to set sheet level access to users in an app.

I'd like to have full access together with another user, while another bunch of users will see respectively a block of sheets named like 1-load, 1-show data etc. I tried using section access like below 

Section Access;

LOAD
ACCESS,
upper(USERID) as USERID,
upper(SHEET) as SHEET,
upper(APPLICATION) as APPLICATION
INLINE [
ACCESS, USERID, SHEET, APPLICATION
ADMIN, ECAS\myself, '*', '*'
ADMIN, INTERNAl\sa_scheduler, '*', '*'
USER, ECAS\user1, 'cd042874-fb27-40b5-924c-fab85d020bd2', '*' // Sheet 1 load
USER, ECAS\user2, '05cee605-5b32-4e47-9cea-a08dccd9a6a1', '*' // Sheet 2 load
];
Section Application;

to give specific access to only 1 sheet to these 2 users, but they keep seeing all sheets. Pointless to say that I've put the sheed IDs in the access table, what am I doing wrong? Looking online seems that there are security rules that would need to be changed in order for it to work but I'm really lost, couldn't find too much documentation like for other tools I have been using so any help is more than welcome!

The alternative would be to create an excel with the list of users and access to each sheet and then use those in the show condition in each sheet, but it doesn't look too clean to me...

Thanks

Fabio

[Or]

There is no such thing as sheet-level access in Qlik Sense, as far as I know.

You can use conditions to hide sheets from some users, but this is not done through Section Access and is not security. 

[rafaelencinas · Accepted solution]

Hi @broddoy 

In your case , try to use Show Conditional field in the sheet 

WildMatch(SHEET,'YourSheetName')

Bye!