Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
Partner - Master

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
Partner - Master

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
Partner - Master

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