Multiple Data Reduction

[rammuthiah]

Hi Guys,

I tried data reduction using 3 fields based on the post in Qlik Community and some replies from the valued community members. Even though I am not able to complete my requirement.

I have n number of Employees

The director wants to see the details of all employees and also the employees only to view their own data. How can I restrict the user from viewing data of others except Director

Data Reduction based on the Employee, Region, County columns

section access;

LOAD * inline [

ACCESS, USER,Employee, Region, County

ADMIN, ADMIN, *

DIRECTOR, APUSER,*,*,*

USER, EUROUSER1,EUROUSER1,EURORegion,EUROCounty

USER, ASIAUSER2,ASIAUSER2,ASIARegion,ASIACounty

USER, NORTHAMERICAUSER3,NORTHAMERICAUSER,NORTHAMERICARegion,NORTHAMERICACounty

];

??????????????????

Message was edited by: RAM MUTHIAH M

[rammuthiah · Accepted solution]

Hi,

I have done with data reduction with 3 level security access. But one problem is that they are allowed to see only restricted data. I want some of the user can see all without restriction. I used '*' for some of the user access, but it seems "Access Denied" while opening the app after refreshed.

Can anyone help me in this regards?

[rammuthiah]

Hi, I tried it works for me perfectly.