

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Gysbert
Can you please help me with section access by providing example script .

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
