Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

rauldip22
New Contributor II

QlickView Row level security access depending on various columns.

Hi!

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

I have four columns of data:

   

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

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.

 

ACCESSUSERIDCOUNTRYEMPLOYEE
ADMINADMIN**
USERKevinUSA
USERKevinMaria
USERKevinEstela
USERMaríaArgentina
USERMaríaKevin
USERCarterUSA
USERCarterPeter
USEREstelaColombia
USEREstelaCarter
USEREstelaMike
USEREstelaRuben
USERMikeCanada
USERMikeDolores
USERMikeGeorge
USERMikeCarlos

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

I attach the files if you can try.

Thanks!