Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Santosh
Contributor III
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;

 

Labels (3)
3 Replies
Gysbert_Wassenaar

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
Contributor III
Contributor III
Author

Hi Gysbert

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

 

Gysbert_Wassenaar

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