Re: Section access - Qlik Community

manu1512 · ‎2018-02-13

Hi all,

Can any one tell how to write script for section access for large number of user.

For me the concern is password, do we need to create for every user and pass it to them

Regards

Manu

akshaye_c_navale · ‎2018-02-13

Hey Manu,

You can used Active directory (NTNAME) in section access instead of user name and password where you don't need password.

For ex.

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, REDUCTION

ADMIN, ADMIN,4

USER, USER,5

];

Section Application;

T1:

LOAD *,

NUM AS REDUCTION;

LOAD

Chr( RecNo()+ord('A')-1) AS ALPHA,

RecNo() AS NUM

AUTOGENERATE 3;

manu1512 · ‎2018-02-13

Can you please explain the section application script

akshaye_c_navale · ‎2018-02-13

REDUCTION is field from dataset on which you want to apply section access.

Dont forgot to check Data reduction and strict exclusion from Document Setting>> Opening.

Go through below link for more details,

Section access