Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rahul_rathore
New Contributor II

How to implement Section Access in Qlik Sense..

Hi All,

I am trying to perform section access in Qlik Sense using below code, but unable to do so....can anyone pls help me here

Sales_Master:

Load * Inline [

Product ID, Country, Geography

P101,       India,   APAC

P102,       Japan,   APAC

P103,       UK,      EMEA

P104,       Austria, EMEA

P105,       USA,     AMER

P106,       CANADA,  AMER

];

EMP:

Load * Inline [

EMP ID, Product ID

E120,   P101

E130,   P101

E140,   P102

E150,   P103

E160,   P105

];

SECTION ACCESS;

Laod * Inline [

ACCESS, USERID, PRODUCT ID

USER,   E120,   P101

USER,   E130,   P101

USER,   E140,   P102

USER,   E160,   *

];

SECTION APPLICATION;


1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: How to implement Section Access in Qlik Sense..

Create new field name PRODUCT ID(upper case) from lower case product id in EMP and Sales_Master table. The reduction field associating section access and section application needs to be in same case.


[Product ID]  as [PRODUCT ID]

9 Replies
omarbensalem
Esteemed Contributor

Re: How to implement Section Access in Qlik Sense..

a section access that works in qlikview should work in qlik sense ENTREPRISE (not desktop)

ps: ur dimension should be in UPPER CASE

rahul_rathore
New Contributor II

Re: How to implement Section Access in Qlik Sense..

How to do data reduction in Qlik sense?

Any example of data reduction..I am struggling with data reduction, security is working fine but when I created one application using above code, I am no longer to access the application.

Bit confusing for me now..

Employee
Employee

Re: How to implement Section Access in Qlik Sense..

In section access, you need to tie "map" one field to another field. In your case, I would think you are attempting to link USER ID to EMP ID; however, you haven't changed the field name from EMP ID, to USER ID. I recommend you duplicate the EMP ID field and alias it with the name USER ID. That way, you will link the two fields together appropriately. Make sure you are a valid user or you will not be able to access the file. You can however open the app with NO DATA.

-gw

Digvijay_Singh
Honored Contributor III

Re: How to implement Section Access in Qlik Sense..

Create new field name PRODUCT ID(upper case) from lower case product id in EMP and Sales_Master table. The reduction field associating section access and section application needs to be in same case.


[Product ID]  as [PRODUCT ID]

agigliotti
Honored Contributor II

Re: How to implement Section Access in Qlik Sense..

first of all in your script there is link from section access to section application fields.

you have to follow what digvijay‌ said above.

remember Qlik is case sensitive and all your fields in section access must be in uppercase.

data reduction works in the same way as in Qlikview.

rahul_rathore
New Contributor II

Re: How to implement Section Access in Qlik Sense..

Thanks Digvijay,

I have made the suggested changes and code is working fine.

rammuthiah
Contributor II

Re: How to implement Section Access in Qlik Sense..

Is it possible to add more reduction like using Country

For Eg.


E140 can view all data and rest of the employees can view only their associated data?

agigliotti
Honored Contributor II

Re: How to implement Section Access in Qlik Sense..

yes of course.

rammuthiah
Contributor II

Re: How to implement Section Access in Qlik Sense..

I tried with reduction for some of the users, it's working. But the user who wants to view the whoe data is not working, It seems "Access Denied" once opening the app after refreshed.

Can anyone advice on how to resolve this?