Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Row Level Access based on two columns

Hi! I have my report with Employees, Salary, his Countries and Supervisors.

I need that each USER (Supervisor) can see only the info of their employees AND ALSO the info of all Employees who have the same country as the supervisor (USER).

This is my data:

    

EmployeeCountrySalarySupervisor
JohnUSA4555Kevin
KevinCanada3425Maria
PeterUSA6000Carter
CarterUSA1345Estela
MariaArgentina9000Kevin
DoloresBrazil3456Mike
EstelaColombia7654Kevin
GeorgeUSA2866Mike
MikeCanada3333Estela
RubenArgentina1234Estela
CarlosColombia7689Mike

I have created this access file:

   

ACCESSUSERIDCOUNTRYSUPERVISOR
ADMINADMIN**
USERKevinUSAKevin
USERMaríaArgentinaMaría
USERCarterUSACarter
USEREstelaColombiaEstela
USERMikeCanadaMike

But when I entry e.g with USERID Kevin, QlikView Filter the combination of (Country == USA AND Supervisor == Kevin) and shows me only the information of "John". What I need is that on this case shows me the info of their supervised people (John, Maria and Estela) and also the info of all the people of USA (Peter, Carter and George).

3 Replies
micheledenardi
Specialist II
Specialist II

Hi Raul,

first of all one advise: Use always UPPERCASE words in your section access. Avoid lots of annoying problems.

Then, if i've understood correctly your SA (for KEVIN) shoud be something like:

   

ACCESSUSERIDSUPERVISORCOUNTRY
ADMINADMIN**
USERKEVINKEVIN*
USERKEVIN*USA
USERDUMMYUSERCARTERUSA
USERDUMMYUSERCARTERCANADA
USERDUMMYUSERCARTERARGENTINA
USERDUMMYUSERCARTERCOLOMBIA
USERDUMMYUSERCARTERBRAZIL
USERDUMMYUSERESTELAUSA
USERDUMMYUSERESTELACANADA
USERDUMMYUSERESTELAARGENTINA
USERDUMMYUSERESTELACOLOMBIA
USERDUMMYUSERESTELABRAZIL
USERDUMMYUSERKEVINUSA
USERDUMMYUSERKEVINCANADA
USERDUMMYUSERKEVINARGENTINA
USERDUMMYUSERKEVINCOLOMBIA
USERDUMMYUSERKEVINBRAZIL
USERDUMMYUSERMARIAUSA
USERDUMMYUSERMARIACANADA
USERDUMMYUSERMARIAARGENTINA
USERDUMMYUSERMARIACOLOMBIA
USERDUMMYUSERMARIABRAZIL
USERDUMMYUSERMIKEUSA
USERDUMMYUSERMIKECANADA
USERDUMMYUSERMIKEARGENTINA
USERDUMMYUSERMIKECOLOMBIA
USERDUMMYUSERMIKEBRAZIL

Do not forget to create the DUMMYUSERS with all the combinations of the SA dimensions.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Why did you use DUMMYUSER?

micheledenardi
Specialist II
Specialist II

Find the working solution on the attached files.

Here the explannation:

Basics for complex authorization

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.