Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xtrimf
Creator
Creator

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
8 Replies
Anonymous
Not applicable

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

)

sunny_talwar

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.

xtrimf
Creator
Creator
Author

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!

xtrimf
Creator
Creator
Author

Hi,

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

xtrimf
Creator
Creator
Author

anyone?

xtrimf
Creator
Creator
Author

maxgro‌ that was it!! tnx

maxgro
MVP
MVP

thanks to Oleg troyansky