Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

slondono
Contributor 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

Tags (2)
1 Solution

Accepted Solutions
shree909
Valued Contributor II

Re: Qlik Sense, Section Access guide

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

5 Replies
Not applicable

Re: Qlik Sense, Section Access guide

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
Contributor II

Re: Qlik Sense, Section Access guide

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

Re: Qlik Sense, Section Access guide

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

Re: Qlik Sense, Section Access guide

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
Valued Contributor II

Re: Qlik Sense, Section Access guide

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