Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team.
will anyone please provide sample section access application .so that i can change the field names and directly run in QMC.
there is no sample application in Qlik community
Please, it's very urgent client is waiting ...
Hi, see and read this post and the example above
Example:
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;
LOAD
Chr( RecNo()+ord('A')-1) AS ALPHA,
RecNo() AS NUM
AUTOGENERATE 3;