Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
cedfoning
Creator
Creator

section access data reduction

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

Labels (3)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

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;

View solution in original post

3 Replies
BrunPierre
Partner - Master II
Partner - Master II

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;

cedfoning
Creator
Creator
Author

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

BrunPierre
Partner - Master II
Partner - Master II

If so, only run the Section Access script under the Hidden Script