Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

Section access

Hello,

I have 20 users and I need to test this thing 

I need to give access based to a Region field , for example i have 3 uses X,Y,Z

 

X can access to region America

Y can access for all regions 

Z can access to region Asia

 

Other users can access to all regions 

 

How to do it (i can use a file contain all users id )

 

Thanks  

1 Solution

Accepted Solutions
Vegar
MVP
MVP

 

SECTION ACCESS;

//The table below could be populated from a list of users instead of my inline table.
SA:
LOAD * inline [ 
ACCESS,USERID, REGION
ADMIN, INTERNAL\SA_SCHEDULER
USER, DOMAIN\X, AMERICAS USER, DOMAIN\Y, * USER, DOMAIN\Z, ASIA USER, DOMAIN\USER1, * [repead all the way down to your las user] USER, DOMAIN\USER20, * ]; //List all REGIONS to ensure the star * to function as intended. REGIONS: LOAD
REGION FROM
LIB:\\DATA\ListOfAllRegions.qvd (qvd); SECTION APPLICATION; //Your regular Load script. //Make sure you have a field called REGION in the datamodel where all values are in UPPER CASE. LOAD ...

 

 

View solution in original post

6 Replies
pradosh_thakur
Master II
Master II

Vegar
MVP
MVP

 

SECTION ACCESS;

//The table below could be populated from a list of users instead of my inline table.
SA:
LOAD * inline [ 
ACCESS,USERID, REGION
ADMIN, INTERNAL\SA_SCHEDULER
USER, DOMAIN\X, AMERICAS USER, DOMAIN\Y, * USER, DOMAIN\Z, ASIA USER, DOMAIN\USER1, * [repead all the way down to your las user] USER, DOMAIN\USER20, * ]; //List all REGIONS to ensure the star * to function as intended. REGIONS: LOAD
REGION FROM
LIB:\\DATA\ListOfAllRegions.qvd (qvd); SECTION APPLICATION; //Your regular Load script. //Make sure you have a field called REGION in the datamodel where all values are in UPPER CASE. LOAD ...

 

 

zied_ahmed1
Specialist
Specialist
Author

I do like this for the first time it doesn't work because we need to publish the application to test 🙂 

zied_ahmed1
Specialist
Specialist
Author

//List all REGIONS to ensure the star * to function as intended.
REGIONS:
LOAD 
REGION FROM
LIB:\\DATA\ListOfAllRegions.qvd (qvd);

(you don't need this )  

Vegar
MVP
MVP

It depends if you med the last part or not. If you use star * and do have more values in REGION than what's defined in the Section Access I recommend you to include it. If not then the star * access is only limited to the total of what the other users may se.
jpk
Partner - Creator II
Partner - Creator II

Hi Everyone

Really great post, most appreciated.

Ebiexperts a Qlik Technology partner has launched an automated Section Access product to the market. 

The product is called SAM: Section Access Manager for Qlik

  • Qlik Integrated & Authenticated
  • Self-service no-code
  • Automation options
  • Active Control SingleTouch
  • Admin
  • E-Learning

This is the MVP release and fully automated. I have attached the brochure.

Regards

JP