QlickView Row level security access depending on various columns.

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

Hi!

I´m trying to apply a little complex type of Security Access into my QlickView report.

I have four columns of 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

On my report each USERID is a Supervisor and I need that each USER (Supervisors) can see the data (Salary, etc.) of all the people of his Country and also the information of their supervised people.

For example: USERID "Kevin" should see all the info of people of USA (John, Peter, Carter and George) AND the info of their supervised (María and Estela).

I´ve created this Access file but it doesn´t works.

ACCESS	USERID	COUNTRY	EMPLOYEE
ADMIN	ADMIN	*	*
USER	Kevin	USA
USER	Kevin		Maria
USER	Kevin		Estela
USER	María	Argentina
USER	María		Kevin
USER	Carter	USA
USER	Carter		Peter
USER	Estela	Colombia
USER	Estela		Carter
USER	Estela		Mike
USER	Estela		Ruben
USER	Mike	Canada
USER	Mike		Dolores
USER	Mike		George
USER	Mike		Carlos

There is a way to apply this type of Access Level?

I attach the files if you can try.

Thanks!

topic QlickView Row level security access depending on various columns. in QlikView

QlickView Row level security access depending on various columns.