Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
asanfelix
Contributor
Contributor

Data filtered by user

Hello,

i have an app with lot of tables related to a master table with information about sales products.

Each product get assigned his brand.

I'd like that "USER01" can only see data about products of brand "BRAND01", and all the other users can see everything.

I have seen posts talking about Section Access, but i'm not able to know how to solve my problem using Section Access.

Is there any way to do this?

Thanks!

2 Solutions

Accepted Solutions
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @asanfelix 

This post by @Dalton_Ruer is probably the best I've seen on the topic. I would recommend working through the PDF and getting an understanding of how section access works before implementing it, otherwise you'll just be guessing. I'm sure his example will help.

Regards,

Mauritz

View solution in original post

124rooski
Partner - Creator
Partner - Creator

section access is pretty simple - I'll take your example for using BRAND01. You want to figure out what your domain and user id is by going into your QMC. Essentially there are 2 parts. Section Access and Section Application. Under the Section Access, you can see I have 3 columns. You must always include the "ADMIN, INTERNAL\SA_SCHEDULER". I added yourself as an Admin since I'm assume you'd want to see all the data, but loaded a regular "user" for the user that should see only BRAND01. The "1" under the "user" line denotes that that user should only see data pertaining to BRAND01. I created a linkage through PRODUCTID as you can see in the script below. If you want to restrict other brands from other users, you can just sequentially add rows underneath the section application script with the the updated brands and add the respective productid number to the section access piece (part 1 of the Section Access). Hope this helps and sheds light. One last thing - make sure your data here is all uppercased. 

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USER_ID, PRODUCTID
ADMIN, domain\*YOUR ID FOUND FROM QMC*, , 
USER, domain\*YOUR USER*, 1
ADMIN, INTERNAL\SA_SCHEDULER,*,
];

SECTION APPLICATION;

LOAD * INLINE [

PRODUCTID, PRODUCT

1, BRAND01

];

View solution in original post

2 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @asanfelix 

This post by @Dalton_Ruer is probably the best I've seen on the topic. I would recommend working through the PDF and getting an understanding of how section access works before implementing it, otherwise you'll just be guessing. I'm sure his example will help.

Regards,

Mauritz

124rooski
Partner - Creator
Partner - Creator

section access is pretty simple - I'll take your example for using BRAND01. You want to figure out what your domain and user id is by going into your QMC. Essentially there are 2 parts. Section Access and Section Application. Under the Section Access, you can see I have 3 columns. You must always include the "ADMIN, INTERNAL\SA_SCHEDULER". I added yourself as an Admin since I'm assume you'd want to see all the data, but loaded a regular "user" for the user that should see only BRAND01. The "1" under the "user" line denotes that that user should only see data pertaining to BRAND01. I created a linkage through PRODUCTID as you can see in the script below. If you want to restrict other brands from other users, you can just sequentially add rows underneath the section application script with the the updated brands and add the respective productid number to the section access piece (part 1 of the Section Access). Hope this helps and sheds light. One last thing - make sure your data here is all uppercased. 

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USER_ID, PRODUCTID
ADMIN, domain\*YOUR ID FOUND FROM QMC*, , 
USER, domain\*YOUR USER*, 1
ADMIN, INTERNAL\SA_SCHEDULER,*,
];

SECTION APPLICATION;

LOAD * INLINE [

PRODUCTID, PRODUCT

1, BRAND01

];