Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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!