Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Section Access Problem

For our section access we have a field called KEY. It's made up of a business line and a region. So a typical KEY might be 1_2. If a sale has KEY 1_2 then a salesperson who has access to KEY 1_2 can see this sale. This works fine but recently we ran into an issue.

There can be more than one salespersons on a sale.

Let's say the sale has KEY 1_2. Then say the sale has 2 salesmen: one salesmen has KEY 1_2 and the other has 2_2 .

SaleMan1 KEY: 1_2

SaleMan2 KEY: 2_2

Sale KEY: 1_2

So for this case we want to give SalesMan2 access to this sale but not the entire 1_2 combo.

Can anyone think of any way to solve this so the can only see "joint" sales. Thanks!

Tags (1)
1 Reply
Not applicable

Section Access Problem

i updated the text, i don't think it made a lot of sense before

Community Browser