Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i'm new to qlik sense, and i have the following issue.
I want to implement a section access in my qlik sense app.
i have the following :
1) in my QMC, i have these users :
BPC\User1,BPC\ User2, BPC\User3
i have created 3 AD group for the 3 users :
ADGroup1 for user1,
ADGroup2 for user2,
ADGroup3 for user3.
Each user is associated to an organisation. this info is in a table in the datamodel. the field name is "orga"
User1 & User2 are in orga1
User3 is in orga2
Now, i want to implement section access with the above infos.
Each user must only see the data corresponding to his organisation.
thanks for your help
I'd do something like this. Remember to save a copy of the app prior to implementing this and check the "Initial Data Reduction Based on Section Access under" settings>Document Properties>Opening.
Table
ACCESS | NTNAME | PASSWORD | ORGA |
ADMIN | BPC\admin | * | * |
USER | BPC\User1 | * | orga1 |
USER | BPC\User2 | * | orga1 |
USER | BPC\User3 | * | orga2 |
Script
SECTION ACCESS;
SECURITY:
LOAD LTRIM(UPPER(ACCESS)) AS ACECESS,
LTRIM(UPPER(NTNAME)) AS NTNAME,
LTRIM(UPPER(ORGA)) AS orga
FROM SectionAcessTable
SECTION APPLICATION;
I'd do something like this. Remember to save a copy of the app prior to implementing this and check the "Initial Data Reduction Based on Section Access under" settings>Document Properties>Opening.
Table
ACCESS | NTNAME | PASSWORD | ORGA |
ADMIN | BPC\admin | * | * |
USER | BPC\User1 | * | orga1 |
USER | BPC\User2 | * | orga1 |
USER | BPC\User3 | * | orga2 |
Script
SECTION ACCESS;
SECURITY:
LOAD LTRIM(UPPER(ACCESS)) AS ACECESS,
LTRIM(UPPER(NTNAME)) AS NTNAME,
LTRIM(UPPER(ORGA)) AS orga
FROM SectionAcessTable
SECTION APPLICATION;
Hello, thanks for your reply
Do i need to create the section acess table as above ?
Like i said, the field "orga" is found in another table in the data model
The users are added via AD in the QMC.
thanks
If so, only run the Section Access script under the Hidden Script