Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qlikconsultant
Contributor 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
Esteemed Contributor

Re: 10% of the customers with highest sale amount

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
Contributor II

Re: 10% of the customers with highest sale amount

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

MVP
MVP

Re: 10% of the customers with highest sale amount

Can you please elaborate little more on your requirement?

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

qlikconsultant
Contributor II

Re: 10% of the customers with highest sale amount

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
Honored Contributor II

Re: 10% of the customers with highest sale amount

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

MVP
MVP

Re: 10% of the customers with highest sale amount

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

Partner
Partner

Re: 10% of the customers with highest sale amount

Calculated Dimension :

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

Partner
Partner

Re: 10% of the customers with highest sale amount

with variable vNumCustomer:

=(Count(Customer_number)*0.1)

Highlighted
daveamz01
Contributor III

Re: 10% of the customers with highest sale amount

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