Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi
different ways to find top performers: community.qlik.com/docs/DOC-5187
Hope it helps you
Regards
How do you determine the busiest air routes with those 3 metrics?
with the no of passengers travelling and revenue from freight and payload..
So how do you handle the situation if they have a higher revenue but not the highest passengers?
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
Hi
different ways to find top performers: community.qlik.com/docs/DOC-5187
Hope it helps you
Regards
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