Re: Create a complex Row Level Access on a QlikView report.
Filtering by two or more values will work all right as long as the premises for the section access table apply:
Only one reduction value per line in the section access table, so for all possible combinations there must be one line for each
When using "*", all values for such field must be specified within the section access table (regardless how the field in the data model looks like). In the section access table, "*" does not mean "all possible values"
Field values and field names are UPPERCASE
Based on your example, for the case of Kevin, there must be a line for each combination of country (including employee's) AND employee:
ACCESS, USERID, COUNTRY, EMPLOYEE
USER, KEVIN, USA, KEVIN
USER, KEVIN, USA, JOHN
USER, KEVIN, USA, PETER
USER, KEVIN, USA, CARTER
USER, KEVIN, USA, GEORGE
USER, KEVIN, CANADA, KEVIN
USER, KEVIN, COLOMBIA, ESTELA
USER, KEVIN, ARGENTINA, MARIA
Because what section access does is the same as when having a selection in the file, you click on File > Reduce Data > Keep Possible Values
So if you select KEVIN in the field Supervisor, all values in white in the fields Employee and Country must be included in the section access.
One way of simplifying this is creating a link table between a key value in one field in the section access table (think of a concatenated key of country & '|' & employee, for example) and another with all possible values.