topic Section Access in QlikView

Section Access

j_qlikview — Mon, 26 Jan 2026 18:19:17 GMT

I need to provide access to couple of people for a dashboard and i have Sales,HR,Marketing,Accounts in which our manager want access to all the four and other people need access to HR,Sales and Accounts how can i do it in section access for a single person i did run this code and it went well but for multiple what i should do.

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, DEPARTMENT

ADMIN, TONY, HR,

USER, ALDA,SALES,

USER, RON,ACCOUNTS,

];

Section Application;

But Tony need access to all the four dept, Alda need access to Sales, HR and accounts how can do section access on this.

Thanks,

Jahnavi

Re: Section Access

krishnacbe — Tue, 19 Apr 2016 21:02:31 GMT

Try with below code

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, DEPARTMENT

ADMIN, TONY, HR,

ADMIN, TONY, SALES,

ADMIN, TONY, ACCOUNTS,

ADMIN, TONY, MARKETING,

ADMIN, TONY, *,

USER, ALDA,SALES,

USER, RON,ACCOUNTS,

];

Section Application;

This is a simple way.

If you have more data in reduction field you need to left join the same with section access table and then include the same within Section Access and Section Application

Regards

Krishnapriya

Re: Section Access

j_qlikview — Wed, 20 Apr 2016 20:45:12 GMT

It did worked and thanks Krishnapriya.......

Jahnavi