topic Re: Row Level Access based on two columns in QlikView

Row Level Access based on two columns

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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:

Employee	Country	Salary	Supervisor
John	USA	4555	Kevin
Kevin	Canada	3425	Maria
Peter	USA	6000	Carter
Carter	USA	1345	Estela
Maria	Argentina	9000	Kevin
Dolores	Brazil	3456	Mike
Estela	Colombia	7654	Kevin
George	USA	2866	Mike
Mike	Canada	3333	Estela
Ruben	Argentina	1234	Estela
Carlos	Colombia	7689	Mike

I have created this access file:

ACCESS	USERID	COUNTRY	SUPERVISOR
ADMIN	ADMIN	*	*
USER	Kevin	USA	Kevin
USER	María	Argentina	María
USER	Carter	USA	Carter
USER	Estela	Colombia	Estela
USER	Mike	Canada	Mike

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).

Re: Row Level Access based on two columns

micheledenardi — Thu, 03 May 2018 14:03:18 GMT

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:

ACCESS	USERID	SUPERVISOR	COUNTRY
ADMIN	ADMIN	*	*
USER	KEVIN	KEVIN	*
USER	KEVIN	*	USA
USER	DUMMYUSER	CARTER	USA
USER	DUMMYUSER	CARTER	CANADA
USER	DUMMYUSER	CARTER	ARGENTINA
USER	DUMMYUSER	CARTER	COLOMBIA
USER	DUMMYUSER	CARTER	BRAZIL
USER	DUMMYUSER	ESTELA	USA
USER	DUMMYUSER	ESTELA	CANADA
USER	DUMMYUSER	ESTELA	ARGENTINA
USER	DUMMYUSER	ESTELA	COLOMBIA
USER	DUMMYUSER	ESTELA	BRAZIL
USER	DUMMYUSER	KEVIN	USA
USER	DUMMYUSER	KEVIN	CANADA
USER	DUMMYUSER	KEVIN	ARGENTINA
USER	DUMMYUSER	KEVIN	COLOMBIA
USER	DUMMYUSER	KEVIN	BRAZIL
USER	DUMMYUSER	MARIA	USA
USER	DUMMYUSER	MARIA	CANADA
USER	DUMMYUSER	MARIA	ARGENTINA
USER	DUMMYUSER	MARIA	COLOMBIA
USER	DUMMYUSER	MARIA	BRAZIL
USER	DUMMYUSER	MIKE	USA
USER	DUMMYUSER	MIKE	CANADA
USER	DUMMYUSER	MIKE	ARGENTINA
USER	DUMMYUSER	MIKE	COLOMBIA
USER	DUMMYUSER	MIKE	BRAZIL

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

Re: Row Level Access based on two columns

Anonymous — Thu, 03 May 2018 14:09:18 GMT

Why did you use DUMMYUSER?

Re: Row Level Access based on two columns

micheledenardi — Thu, 03 May 2018 14:58:30 GMT

Find the working solution on the attached files.

Here the explannation:

Basics for complex authorization