Section access

[manu1512]

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]

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]

Can you please explain the section application script

[akshaye_c_navale]

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,

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Security.htm