Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

eldad123
New Contributor III

count top 10% customers

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....

1 Solution

Accepted Solutions
MVP
MVP

Re: count top 10% customers

8 Replies
galax_allu
Valued Contributor

Re: count top 10% customers

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

)

MVP
MVP

Re: count top 10% customers

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.

eldad123
New Contributor III

Re: count top 10% customers

Hi,

I'm not including boundry values.

and anyways the diff is way to high.

here is some data:

Item Quantity % Acc
1158517333.5%
1158524205.6%
4923099157.2%
46148.8%
11587221310.2%
911311.6%
1883551312.9%
9647751214.2%
221215.5%
72960732306631216.8%
11585311118.0%
9225911119.2%
23313221120.3%
6887321021.4%
1692922.3%
480923.3%
1715824.1%
262239724.8%
8909877725.5%
121726.2%
1158661626.9%
1158500627.5%
187709628.1%
1158579628.7%
1158548629.3%
176629.9%
964300530.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!

eldad123
New Contributor III

Re: count top 10% customers

Hi,

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

eldad123
New Contributor III

Re: count top 10% customers

anyone?

MVP
MVP

Re: count top 10% customers

eldad123
New Contributor III

Re: count top 10% customers

maxgro‌ that was it!! tnx

MVP
MVP

Re: count top 10% customers

thanks to Oleg troyansky