Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
manu1512
New Contributor III

Section access

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

3 Replies
itsakshaye
New Contributor III

Re: Section access

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
New Contributor III

Re: Section access

Can you please explain the section application script

itsakshaye
New Contributor III

Re: Section access

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

Community Browser