Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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.
This Option is called "Dimensions Limit" and how I said it delivers not the desired result.
Can you please elaborate little more on your requirement?
if possible, provide one small example... Would like to help you on this.
Ok here is an example:
Goal 10% of the the customers with the highest sale:
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
10% of customers with highest price... What is the criteria for comparing !!...
Calculated Dimension :
with variable vNumCustomer:
You can use Dimension Limit with this settings:
Show only = Largest xxx values where xxx can be calculated dynamically like count(customers) * 10%.