Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
NiTo
Creator
Creator

Section Access

Hi Qlikians,

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

 

NiTo_0-1690467018371.png

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

 

Labels (1)
1 Solution

Accepted Solutions
Sebastian_Dec
Creator II
Creator II

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

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

5 Replies
Sebastian_Dec
Creator II
Creator II

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

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.
NiTo
Creator
Creator
Author

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
Creator II
Creator II

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
];	

 

 

 

 

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.
NiTo
Creator
Creator
Author

Thanks Sebastian.

Unfortunately, it is incorrect.

Sebastian_Dec
Creator II
Creator II

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

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.