

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlik Sense, Section Access guide
Hi guys
Im trying to find a document, video, guide, etc. Where it shows how to deploy Section Access in Qlik Sense. Any of you have information about it?
Thank u all
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Reduction means it can be any field that you want to reduce the data.
Yes you can use Year as one of your reduction field.
make sure that you tie this reduction field to the Datamodel to reduce the data...
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
section access;
LOAD * inline [
ACCESS, USERID,REDUCTION, OMIT
USER, AD_DOMAIN\ADMIN,*,
USER, AD_DOMAIN\A,1,
USER, AD_DOMAIN\B, 2,NUM
USER, AD_DOMAIN\C, 3, ALPHA
USER, INTERNAL\SA_SCHEDULER,*,
];
section application;
T1:
LOAD *,
NUM AS REDUCTION;
The result will be:
- User ADMIN can see all fields and only those records other users can see in this example when REDUCTION is 1,2, or 3.
- User A can see all fields, but only those records connected to REDUCTION=1.
- User B can see all fields except NUM, and only those records connected to REDUCTION=2.
- User C can see all fields except ALPHA, and only those records connected to REDUCTION=3.
The INTERNAL\SA_SCHEDULER account user is required to enable reload of the script in a Qlik Management Console task.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But 'Reduction' is a keyword? or the name of the field.
For example, if a have a fiel Year and i just want user A get access only to the year 2015, how would it be??
LOAD * INLINE [
ACCESS, USERID, YEAR
USER, domain\A, 2015
];
I dont know, can someone explain me please?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Section Access;
LOAD * INLINE [
ACCESS, USERID, REDUCTION
ADMIN, 1,1
USER, 2,2
USER, 3,3
ADMIN, INTERNAL\SA_SCHEDULER,
];
Section Application;
InDataModel:
LOAD * INLINE [
REDUCTION, year
1,2015
2,2014
3,2015
INTERNAL\SA_SCHEDULER,
];
here reduction on user and Year

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Section Access;
LOAD * INLINE [
ACCESS, USERID, REDUCTION
ADMIN,DOMAIN\A,A
USER, DOMAIN\B,B
USER,DOMAIN\C,C
ADMIN, INTERNAL\SA_SCHEDULER,
];
Section Application;
InDataModel:
LOAD * INLINE [
REDUCTION, year
A,2015
B,2014
C,2016
INTERNAL\SA_SCHEDULER,
];
HERE REDUCTION IS FIELD WHERE WHICH ONE WANT TO RESTRICT USER


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Reduction means it can be any field that you want to reduce the data.
Yes you can use Year as one of your reduction field.
make sure that you tie this reduction field to the Datamodel to reduce the data...
Thanks
