Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
qlikconsultant
Creator II
Creator II

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
datanibbler
Champion
Champion

Hi Markus,

I think on the GUI you have the option, in the dialog of pretty much any chart, to limit the displayed values. I have never used that, so I cannot advise you further on that, but it should be possible.

HTH

Best regards,

DataNibbler

qlikconsultant
Creator II
Creator II
Author

This Option is called "Dimensions Limit" and how I said it delivers not the desired result.

MK_QSL
MVP
MVP

Can you please elaborate little more on your requirement?

if possible, provide one small example... Would like to help you on this.

qlikconsultant
Creator II
Creator II
Author

Ok here is an example:

Basic data:

 

Customer numberSales €Orders
1.€ 20,001
2.€ 30,003
3.€ 40,004
4.€ 10,002
5.€ 2,001
6.€ 20,0010
7.€ 15,003
8.€ 20,004
9.€ 10,005
10.€ 90,006
11.€ 180,0020
12.€ 30,0010
13.€ 20,002
14.€ 20,001
15.€ 50,005
16.€ 200,0010
17.€ 10,0020
18.€ 80,008
19.€ 10,001
20.€ 20,002

Goal 10% of the the customers with the highest sale:

 

Customer numberSales €Orders
11.€ 180,0020
16.€ 200,00

10

rustyfishbones
Master II
Master II

You could try for just the top 2

IF(AGGR(RANK(Sum(Sales)),[Customer number])<=2,[Customer number])

However I believe you could more customers and therefore this list needs to dynamically change based on the Customers.

I will take a further look

Regards

Alan

MK_QSL
MVP
MVP

10% of customers with highest price... What is the criteria for comparing !!...

jpenuliar
Partner
Partner

Calculated Dimension :

=Aggr(if(Rank(Sum(Sales_€))<= $(vNumCustomer),Customer_number),Customer_number)

jpenuliar
Partner
Partner

with variable vNumCustomer:

=(Count(Customer_number)*0.1)

daveamz01
Creator III
Creator III

Hi Markus,

You can use Dimension Limit with this settings:

Show only = Largest xxx values where xxx can be calculated dynamically like count(customers) * 10%.

Best regards,

David