Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA.
I need to implement section access in Qlik sense .
I have attached the excel file and we have same format.
Could you please suggest how to apply section access in Qliksense.
Also , Please suggest how to specify section access for respective group.
Regards,
Kishor
please take a look at working with SA in Qliksense qmc
Hi Kishor,
SECTION ACCESS ;
SA:
LOAD
userid AS NTNAME,
if(value='admin','ADMIN','USER') AS ACCESS,
value AS VALUE_KEY
FROM yourdataset;
SECTION APPLICATION ;
YourTable:
LOAD
Fields,
value AS VALUE_KEY
FROM anotherdataset;
The values from your excel should exist in you dataset. That's how Section Access Works.
This is not working.
SECTION ACCESS ;
LOAD userid AS NTNAME,
if(value='admin','ADMIN','USER') AS ACCESS,
value AS VALUE_KEY
FROM [lib://SectionA (cabtest_svc_cdpadmin)/ad.xlsx] (ooxml, embedded labels, table is Sheet2);
SECTION APPLICATION ;
LOAD userid as NTNAME,
name
FROM [lib://SectionA (cabtest_svc_cdpadmin)/ad.xlsx] (ooxml, embedded labels, table is Sheet1);
How do we apply section access for sample data in attached excel.
So that when ever resp user can be logged in resp data can be shown
Thanks
Hi Kishor,
Your correct that it isn't working. The field VALUE_KEY was intended to be used as the link between your section access and your data, not the NTNAME. No problem, now i've got some extra insight in what you want to accomplish.
SECTION ACCESS ;
LOAD
UPPER(userid) AS NTNAME,
if(value='admin','ADMIN','USER') AS ACCESS,
UPPER(userid) AS VALUE_KEY
FROM [lib://SectionA (cabtest_svc_cdpadmin)/ad.xlsx] (ooxml, embedded labels, table is Sheet2);
SECTION APPLICATION ;
LOAD
UPPER(userid) as VALUE_KEY,
userid,
name
FROM [lib://SectionA (cabtest_svc_cdpadmin)/ad.xlsx] (ooxml, embedded labels, table is Sheet1);
When ever I am reloading the application I am not able to open it again.
Please suggest
Is your USERID part of the data?
Maybe try loading the application without SECTION APPLICATION; and SECTION ACCESS;
Just check your data model and make selections so you'll get more grip the section access.
i am building Sample section access mechanism in qlik sense.
We have userid defined and userid same as our domain users
Probably adding DOMAIN\USERID instead of USERID. You check that with a simple textbox with the function USERID()