topic Re: Section access in App Development

Section access

sreeramhbk — Sat, 16 Nov 2024 06:28:50 GMT

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.

Re: Section access

v_veronesi — Wed, 27 Feb 2019 12:11:11 GMT

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.

Re: Section access

sreeramhbk — Wed, 27 Feb 2019 12:19:01 GMT

Hi V_veronesi,

1)Yes, we are using Qlik Sense enterprise

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

Many thanks.

Re: Section access

v_veronesi — Wed, 27 Feb 2019 12:22:52 GMT

You should try creating the task to reload that app.

Re: Section access

SONIAGESIMDE — Thu, 28 Mar 2019 12:13:26 GMT

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,