Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kishorj1982
Contributor

Section access in qlik sense

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

8 Replies
agigliotti
Honored Contributor II

Re: Section access in qlik sense

please take a look at working with SA in Qliksense qmc

avkeep01
Valued Contributor

Re: Section access in qlik sense

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
Contributor

Re: Section access in qlik sense

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
Valued Contributor

Re: Section access in qlik sense

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
Contributor

Re: Section access in qlik sense

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

Please suggest

avkeep01
Valued Contributor

Re: Section access in qlik sense

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
Contributor

Re: Section access in qlik sense

i am building Sample section access mechanism in qlik sense.

We have  userid defined and userid same as our domain users

avkeep01
Valued Contributor

Re: Section access in qlik sense

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