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: 
Not applicable

Displaying top 5 customers in bar chart

How can this be done

I have numerous customers, however, I only want to display the first 5

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Under Chart Properties > Dimension Limits > Select Show Only Largest 5 Values, then Deselect 'Show Others' under 'Options':

Capture.JPG

View solution in original post

7 Replies
Anonymous
Not applicable
Author

use dimension limits tab in chart properties and select option first 5 values

manojkvrajan
Luminary
Luminary

Attached is the sample application with the bar chart. All you need to do is just restrict the maximum visible bars to 5 and sort the Y axis to descending. I hope this helps.

Not applicable
Author

When I restrict the values to the top 5, im given a list of the top 4 customers and then the 5th is an accumulation of all the other customers.

So, for instance, if my sales figure was 100

Cust 1 - 10

Cust 2 - 5

Cust 3 - 3

Cust 4 - 2

Other - 80

This completely distorts the chart.

How can I have the top 5 customers?

Thanks

Not applicable
Author

=aggr(if(rank(sum([Order Amount]))<=0,Customer),Customer)

Use something like this as the dimension

Not applicable
Author

Under Chart Properties > Dimension Limits > Select Show Only Largest 5 Values, then Deselect 'Show Others' under 'Options':

Capture.JPG

Not applicable
Author

Right in front of me (as always!)

Thank you

Not applicable
Author

Thank You