Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

Data Reduction - Issue

I tried data reduction using 3 fields Region, Level1, Level2

I want to do for some of Level1 can access globally.

For eg : Arun can see all Level2

Region,Level1,Level2

AP, Ram, Sam

AP, Arun, *

AP, Kumar, Ravi


By Region, I have done. But multiple data reduction is not working fine for myself. Could anyone help me in this scenario?

After refreshing the data, it seems "Access Denied" if I try to open the dashboard.

4 Replies
pedrolyra
New Contributor III

Re: Data Reduction - Issue

Hey, can you copy paste the code you are using here please?

mikaelsc
Contributor III

Re: Data Reduction - Issue

define your reduction on the lowest possible level. that's usually the easiest thing to do:

if you have 3 Locations:

Region, Level1, Level2

AP,Sea,Location1

AP,Sea,Location2

AP,Mountain,Location3

you should define the access like this if you want Arun to have access to all the Sea Level1:

User,Level2

Arun,Location1

Arun, Location2

Kumar,Location3

It's the easiest and the most overviewable, especially because the * may not work if you don't list all the possible values in your access table.

rammuthiah
Contributor II

Re: Data Reduction - Issue

If I have n no. of list, Should I define all possible members? And If I kept empty instead of *, I couldn't access the app

My scenario is like Director can see all employees details, but employees can view their own data as well region level.

Consider Arun is the Director, he can view all employees data where rest of them can view their own data and their below level employee's data

Region,Level1,Level2

AP, Ram, Sam

AP, Arun, *

AP, Kumar, Ravi

mikaelsc
Contributor III

Re: Data Reduction - Issue

yes, again, section access is not a hierarchy table, it's linking the user to what she/he is allowed to see. (1 to 1, but a user may appear several times in the table)

and yes, you should list all the possible values for your lowest level. if you don't have the list, you may be able to generate it in your script?