Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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!

0 Replies