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

how to get top analysis

how to get top ten field values in straight table or pivot table

I am working on an application where I have to take out top ten bussiest air routes

I have origin and destination description as dim

I have sum of passengers ,sum of freight and sum of payload as my measures,but they are not in order

I need to get these values in order, what  expression I need to type..plz  help..

1 Solution

Accepted Solutions
maxgro
MVP
MVP

Hi

different ways to find top performers:    community.qlik.com/docs/DOC-5187

Hope it helps you

Regards

View solution in original post

6 Replies
jpapador
Partner - Specialist
Partner - Specialist

How do you determine the busiest air routes with those 3 metrics?

Not applicable
Author

with the no of passengers travelling and revenue from freight and payload..

jpapador
Partner - Specialist
Partner - Specialist

So how do you handle the situation if they have a higher revenue but not the highest passengers?

Not applicable
Author

it is so obvious that if revenue generation is more then good no of passenger must be travelling and I have other facts related to this, that are there. i have tried using firstordervalue but somehow I am not able to get right expression but I am  thank full for your replies ,I will somehow find my way.

thanks

maxgro
MVP
MVP

Hi

different ways to find top performers:    community.qlik.com/docs/DOC-5187

Hope it helps you

Regards

Not applicable
Author

Hey Sudhanshu,

If you are using QV 11 you can use the dimension limit option. Its quite powerful.

If you are using older versions you can use rank function to determine the order and then suppress the rest.

If you have trouble please attach a sample doc with some dummy data.

Thanks

AJ