Section Access

[NiTo]

Hi Qlikians,

I want to know if something like this in Section Access is possible. Please have a look at the table below:

I want Manager TTT to view the sales of Region Telangana alone but able to see the sales of entire South region. Is this possible in section access??

[Sebastian_Dec]

Yes, you can do that by managing data security with Section Access.

Read this article:

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

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage...

[NiTo]

Hello Sebastian and thanks for your reply. I did went through the link earlier, but I did not understand much as I am new to qlik sense. For eg,  giving numbers to Reduction fields. How it will be connected to the data that is available in my Table? How it will restrict TTT to view some data??

Thanks,

[Sebastian_Dec]

Sorry, I don't have a good solution because I haven't tried it yet (I plan to), but from what I've read this code should work), it's given in the example.

You only need USERID and/or USER.EMAIL.

Code should be first in Data Load Editor

Section Access;
LOAD * INLINE [
    ACCESS,  USERID,      USER.EMAIL,                   Manager
    USER,    ABC\Joe,     *,                            ZZZ          
    USER,    *,           joe.smith@example.com,        ZZZ
    USER,    ABC\Ursula,  *,                            YYY
    USER,    *,           ursula.schultz@example.com,   YYY
    USER,    ABC\Stefan,  *,                            TTT
    USER,    *,           stefan.svensson@example.com,  TTT
];	

[NiTo]

Thanks Sebastian.

Unfortunately, it is incorrect.

[Sebastian_Dec · Accepted solution]

Hi, this code works (iI tried and it works for me), You have to match the code to yourself.

"SectionAccess;" must be at the beginning,
Contact the admin what are the userIDs,
Manager must be uppercase,

Section Access;
Authorization:
LOAD * INLINE [
    ACCESS,  USERID,			MANAGER
    USER,    DOMAIN\UserA,     	ZZZ          
    USER,    DOMAIN\UserA,     	YYY
    USER,    DOMAIN\UserA,     	TTT
];	

Then you need to use "Section Application;" before  when loading data:

Section Application;
Table:
LOAD 
A,
B,
....

This video also explains a lot:

https://www.youtube.com/watch?v=0VoJPiRrqKA