Section access

[zied_ahmed1]

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  

[pradosh_thakur]

The Qlik helps explains it clearly

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

[Vegar · Accepted solution]

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]

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

[zied_ahmed1]

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

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]

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