Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikconsultant
Creator III
Creator III

10% of the customers with highest sale amount

Hi,

I’m looking for a way to show 10% of the customers with highest sale amount?

I tried it with dimensions limit but it gets me only the customers with 10 % of the sale amount.

Any suggestions?

10 Replies
rustyfishbones
Master II
Master II

Create a Calculated Dimension with

2015-02-20_1301.png

Ensure to Suppress 0 Values

2015-02-20_1301_001.png

And your Expression will be Sum(Sales)