Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
slondono
Partner - Creator II
Partner - Creator II

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

1 Solution

Accepted Solutions
shree909
Partner - Specialist II
Partner - Specialist II

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

View solution in original post

5 Replies
Not applicable

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
Partner - Creator II
Partner - Creator II
Author

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?

Not applicable

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

Not applicable

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
Partner - Specialist II
Partner - Specialist II

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