Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
rauldip22
New Contributor II

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
Highlighted
micheledenardi
Valued Contributor

Re: Row Level Access based on two columns

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.

rauldip22
New Contributor II

Re: Row Level Access based on two columns

Why did you use DUMMYUSER?

micheledenardi
Valued Contributor

Re: Row Level Access based on two columns

Find the working solution on the attached files.

Here the explannation:

Basics for complex authorization