Hi all,
It's a bit of a vague question, but I'll try to create an example here:
Say I had some salesmen, each with a value of the sales made. For example
Salesman, Total Sales
A, 200
B, 650
C, 400
D, 210
E, 520
From the above, I can manually ascertain that :
2 Salesmen (B,E) are responsible for approx. 59% of the total sales
20% of salesmen are responsible for 59% of total sales
3 Salesmen (B,C,E) are responsible for approx. 79% of the total sales
60% of salesmen are responsible for 79% of total sales.
I am trying to represent this in Qlikview with much larger data sets, which makes doing this manually somewhat impossible. I'd like to identify situations where the distribution of the overall sales is weighted heavily on certain salesmen; where a smaller proportion of has contributed to a relatively larger portion of .
If anyone has any suggestions on both how to script this function, and even some good ideas on how to represent this kind of data, it would be very much appreciated!
