topic Re: Set Analysis - Thresholds in QlikView

Set Analysis - Thresholds

zagzebski — Thu, 15 Aug 2013 11:44:23 GMT

I don't even know if this is possible. I need to find how much makes up the top 80% in sales and the count of how many clients by sales person:

Salesperson	Client	Sales
Sue	A	35
Sue	B	55
Sue	C	75
Sue	D	70
Sue	E	80
Dave	F	20
Dave	G	60
Dave	H	100
Dave	I	140
Dave	J	180

RESULTING OBJECT:

	80% Sale Threshold	# of Clients making up 80%
Sue	225	4
Dave	420	3

For Sue Client's E,D,C,and B are her top clients-making up 80% of her sales

for Dave clients J, I, and H are his top clients making up 80% of his sales

Is it possible to write set analysis that would add up what80% of salespersons business is and how many client made up that 80%?

Re: Set Analysis - Thresholds

Gysbert_Wassenaar — Thu, 15 Aug 2013 12:15:39 GMT

The only way I know of is to do some calculations in the script first. See attached example.

Re: Set Analysis - Thresholds

zagzebski — Thu, 15 Aug 2013 12:50:53 GMT

Thanks! Good to know I need not spend alot of time trying to figure out some set analysis.

One quick follow up - if I added the extra complexity of trying to compare the clients (that made the upper 80%) to that clients prior year amount is that even possible? (for example in the example above if I selected on 80% I would want Sues clients (for example) E,D,C, and B for the prior year). Or am I asking for a nightmare..

Re: Set Analysis - Thresholds

zagzebski — Thu, 15 Aug 2013 12:55:25 GMT

I have never used fractile - but is there any way to incorporate that?