Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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:
The INTERNAL\SA_SCHEDULER account user is required to enable reload of the script in a Qlik Management Console task.
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?
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
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
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