Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Santosh
New Contributor III

Section Access In Qliksense

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;

 

3 Replies
MVP & Luminary
MVP & Luminary

Re: Section Access In Qliksense

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. 

 


talk is cheap, supply exceeds demand
Santosh
New Contributor III

Re: Section Access In Qliksense

Hi Gysbert

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

 

MVP & Luminary
MVP & Luminary

Re: Section Access In Qliksense

You can find an example on the help page: https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/m...


talk is cheap, supply exceeds demand