topic Re: count top 10% customers in QlikView

count top 10% customers

xtrimf — Sun, 25 Sep 2016 15:31:45 GMT

Hi,

I need to display in a textbox how many customers are in the top 10%...

Itried to use

count({$<Customer= P({<Sales ={">=$(=Fractile(Total Sales,0.9))"}>} Customer)>} DISTINCT Customer)

but didn't get the same results as I get when using Dimension Limitation in a chart object....

Re: count top 10% customers

Anonymous — Mon, 26 Sep 2016 15:59:11 GMT

May be try this ?

Other functions can be used quite effectively within an AGGR like this. For example:

=if(

Aggr(Rank(Sum(Sales)), customer)<=10,

Country

)

Re: count top 10% customers

sunny_talwar — Mon, 26 Sep 2016 16:08:59 GMT

Are you including boundary values in the dimension limits? AFAIK the result of dimension limits and fractile doesn't always match perfectly. If you can share a sample, we might be able to propose an alternative.

Re: count top 10% customers

xtrimf — Mon, 26 Sep 2016 16:55:57 GMT

Hi,

I'm not including boundry values.

and anyways the diff is way to high.

here is some data:

Item	Quantity	% Acc

1158517	33	3.5%
1158524	20	5.6%
4923099	15	7.2%
46	14	8.8%
1158722	13	10.2%
91	13	11.6%
188355	13	12.9%
964775	12	14.2%
22	12	15.5%
7296073230663	12	16.8%
1158531	11	18.0%
922591	11	19.2%
2331322	11	20.3%
688732	10	21.4%
1692	9	22.3%
480	9	23.3%
1715	8	24.1%
262239	7	24.8%
8909877	7	25.5%
121	7	26.2%
1158661	6	26.9%
1158500	6	27.5%
187709	6	28.1%
1158579	6	28.7%
1158548	6	29.3%
176	6	29.9%
964300	5	30.5%

When using Dimension limit "show only values that accumulate to" , lets say %10, then it will leave 4 first rows.

I need to achieve the result "4" with a seperate calc , best also I f I could get these Items with concat...

tnx!

Re: count top 10% customers

xtrimf — Mon, 26 Sep 2016 16:57:29 GMT

Hi,

I am talking about accumulative percentage - it cannot be achieve the way you suggested, please look below for an example

Re: count top 10% customers

xtrimf — Mon, 17 Oct 2016 20:12:00 GMT

anyone?

Re: count top 10% customers

maxgro — Mon, 17 Oct 2016 21:00:14 GMT

maybe here

http://www.naturalsynergies.com/q-tip-11-so-how-many-customers-make-up-most-of-your-sales/

Re: count top 10% customers

xtrimf — Thu, 20 Oct 2016 09:27:05 GMT

maxgro‌ that was it!! tnx

Re: count top 10% customers

maxgro — Thu, 20 Oct 2016 10:23:53 GMT

thanks to Oleg troyansky‌