Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kristien
New Contributor II

How to combine multiple criteria to set dynamic datareduction with section access

Hi,

I want to set up dynamic datareduction in a sales application.

The purpose is that a sales representative can only see what belongs to him.

The problem is that there are 2 levels where a salesrep is linked: each customer is linked to a salesrep , and each order is also linked to a salesrep, normaly this will be the salesrep that is linked to the customer, but sometimes it may be another salesrep.

The purpose is that a salesrep may see all facts that are linked to his customer + all facts where he is directly linked to

i.e. 3 salesreps: X, Y and Z:

SALESREP_CUSTOMER

SALESREP_SALES

Access for

Customer A

Order 1

X

X

X

Order 2

X

Z

X + Z

Order 3

X

X

X

Customer B

Order 4

Y

Y

Y

Order 5

Y

Z

Y + Z

Salesrep X may see Order 1, Order 2, Order 3 (because he is linked to the customer)

Salesrep Y may see Order 4 and Order 5 (because he is linked to the customer)

Salesrep Z may see Order 2 and Order 5 (because he is linked to the order)

Is this possible to set up security for this in Section Access?

I.e: can I Load 2 tables in Section Access, one referring the first dimension and the second referring to the second dimension? And will the 2 rules be added, or will the second overrule the first?

Like this:

section access;

LOAD * inline [

ACCESS, USERID, SALESREP_CUSTOMER,OMIT

USER,AD_DOMAIN\X,X,

USER,AD_DOMAIN\Y,Y,

USER,AD_DOMAIN\Z,Z,

];

LOAD * inline [

ACCESS, USERID, SALESREP_SALES,OMIT

USER,AD_DOMAIN\X,X,

USER,AD_DOMAIN\Y,Y,

USER,AD_DOMAIN\Z,Z,

];

regards,

Kristien

Community Browser