Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sreeramhbk
Contributor III
Contributor III

Section access

Hi,

We are trying to implement column level security using Section access in Inline script. We want to show the admin user all the values in the field and one user(zzz) should see only "sales" values. We used the below script. But we are not able achieve the results.

Section Access:

LOAD * INLINE[

USER,ACCESS,FILE_NAME

ADMIN,AD_DOMAIN\ADMIN,

USER,AD_DOMAIN\ZZZ,SALES

];

Section Application;

load process_id,file_name,file_count from table;

 

Please assist us in achieving the required result.

Labels (2)
4 Replies
v_veronesi
Partner - Contributor II
Partner - Contributor II

Hi Sreeramhbk ,
I have two questions:

1-Are you using Qlik Sense Enterprise isn't it?

2- Are you reloading the app with a task from QMC? Because section access need to be reload from there.

 

sreeramhbk
Contributor III
Contributor III
Author

Hi V_veronesi,

1)Yes, we are using Qlik Sense enterprise

2) No, we haven't create any tasks for reloads.

 

Many thanks.

 

v_veronesi
Partner - Contributor II
Partner - Contributor II

You should try creating the task to reload that app.

SONIAGESIMDE
Contributor II
Contributor II

You need a field for data reduction, which links the inline table with your model.
This video can help you understand the access section:

https://www.youtube.com/watch?v=Cq4QzR9s7AA&feature=youtu.be

Regards,