Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Section Access for multiple fields

Hi,

What is the best way (without Publisher) to achieve a flexible security model to handle data similar to this:

Product,Market,Amount

Bikes,Sweden,100

Bikes,Norway,50

Cars,Norway,10

Cars,France,50

I have:

One Product manager who should have access to Cars for all markets.

One Country manager who should have access to all products in Norway

One local Product manager who should have access to Bikes-sales in Sweden only.

I would want to avoid creating a security field like Bikes_Sweden as I have 100+ products and 100+ markets, although that migh be a solution. Then mapping up each user with all combinations that they should have access to.

This should be a fairly common issue for QlikView users?

How have you solved it?

Kind regards

Niklas

Community Browser