Section access in qlik sense

[kishorj1982]

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

[agigliotti]

please take a look at working with SA in Qliksense qmc

[avkeep01]

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.

[kishorj1982]

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

[avkeep01]

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);

[kishorj1982]

When ever I am reloading the application I am not able to open it again.

Please suggest

[avkeep01]

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.

[kishorj1982]

i am building Sample section access mechanism in qlik sense.

We have  userid defined and userid same as our domain users

[avkeep01]

Probably adding DOMAIN\USERID instead of USERID. You check that with a simple textbox with the function USERID()