Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
j_qlikview
Creator
Creator

Section Access

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

1 Solution

Accepted Solutions
krishnacbe
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

2 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

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

j_qlikview
Creator
Creator
Author

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

Jahnavi