topic Re: Section access in QlikView

Section access

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 13 Feb 2018 17:38:33 GMT

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 — Tue, 13 Feb 2018 17:55:48 GMT

Can you please explain the section application script

akshaye_c_navale — Tue, 13 Feb 2018 18:01:52 GMT

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,