Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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]
a section access that works in qlikview should work in qlik sense ENTREPRISE (not desktop)
ps: ur dimension should be in UPPER CASE
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..
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
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]
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.
Thanks Digvijay,
I have made the suggested changes and code is working fine.
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?
yes of course.
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?