Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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
Highlighted
Master III
Master III

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]

View solution in original post

9 Replies
Highlighted
Partner
Partner

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

ps: ur dimension should be in UPPER CASE

Highlighted
Contributor II
Contributor II

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..

Highlighted
Employee
Employee

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

Highlighted
Master III
Master III

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]

View solution in original post

Highlighted
Partner
Partner

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.

Highlighted
Contributor II
Contributor II

Thanks Digvijay,

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

Highlighted
Creator II
Creator II

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?

Highlighted
Partner
Partner

yes of course.

Highlighted
Creator II
Creator II

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?