topic Section Access vs Complete data in QlikView

Section Access vs Complete data

Fri, 25 Mar 2011 20:48:13 GMT

Hi,

Suppose Div 1 has salespeople A,B, C

A made 50, B made 30, and C made 20

With Section Access, A is limited to the records under his name.

But if I want to get the % compared to the whole Div (50/100=50%), how do I get it?

My understanding is that data is still there, and I tried "all" and "total" but didn't work.

Thanks in advance.

Section Access vs Complete data

pover — Fri, 25 Mar 2011 21:39:52 GMT

No, the unrelated data is not there after section access. What I've done in this case is load another table in the script that is not linked to the salesperson. The additional table contains the total sales of each division and is linked to the rest of the model by the division.

Regards.