Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
jacmiller
Contributor
Contributor

How do I use the Max() to get top 5 or top 10 performers

Hello,

I have a data where the customer wants to see the top 5-10 engine model performers.

is the max function teh best one to use to make a chart show me the top ten? also how would i use it?

my field name/measure that i want to see is STD_Count, and the values in the field are just numbers i.e. 14,20,200,308.

i just want the top ten shown on the chart. my dimension is labled 'ENG_MDL'

please help!

Thank you!

-Jake

1 Solution

Accepted Solutions
galax_allu
Specialist
Specialist

=if(Aggr(Rank(Sum(STD_Count)), ENG_MDL)<=10, ENG_MD, 'Others')

View solution in original post

2 Replies
galax_allu
Specialist
Specialist

=if(Aggr(Rank(Sum(STD_Count)), ENG_MDL)<=10, ENG_MD, 'Others')

View solution in original post

jacmiller
Contributor
Contributor
Author

This is perfect, thank you!