topic Re: Section Access In Qliksense in App Development

Section Access In Qliksense

Santosh — Sat, 16 Nov 2024 06:59:01 GMT

HI All,

I want to implement below section access in qliksense the script is written in QV . can any one help me

USERMASTER:
LOAD DISTINCT USERID AS UMUSERID,REGION,
COMPANY;
SQL SELECT * FROM qlikview_Access where UPPER(Report_Name) = 'XYZ';

left join LOAD

USERID as UMUSERID,PASS AS UMPASS,USER_ACCESS AS UMACCESS;
SQL SELECT * FROM USER_MASTER where USERID IN (SELECT USERID FROM qlikview_Access where UPPER(Report_Name) = 'XYZ');

Section Access;

User_access:
LOAD UMUSERID as USERID,UMPASS as PASSWORD,UMACCESS AS ACCESS,REGION,
COMPANY RESIDENT USERMASTER;

Section Application;
STAR IS ALL;

QUALIFY *;
USERS:
LOAD UM_USERID as USERID,UM_ACCESS AS ACCESS RESIDENT USER_MASTER;

Re: Section Access In Qliksense

Gysbert_Wassenaar — Tue, 25 Dec 2018 12:55:45 GMT

Section Acces works a little different in Qlik Sense. The userid must also be a Qlik Sense user. You can't just put arbitrary user-password combinations in the access table like you can in Qlikview. You can put a PASS column in the Section Access table if you like, but it will not be used for authenticating the user since that is already done by Qlik Sense when the user logged in.

Re: Section Access In Qliksense

Santosh — Tue, 25 Dec 2018 13:26:08 GMT

Hi Gysbert

Can you please help me with section access by providing example script .

Re: Section Access In Qliksense

Gysbert_Wassenaar — Tue, 25 Dec 2018 16:07:07 GMT

You can find an example on the help page: https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm