Qlik Sense, Section Access guide

[slondono]

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

[#2]

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.

[slondono]

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?

[#4]

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

[#5]

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

[shree909 · Accepted solution]

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