topic Re: how to get top analysis in QlikView

how to get top analysis

Thu, 16 Jan 2014 16:55:56 GMT

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..

Re: how to get top analysis

jpapador — Thu, 16 Jan 2014 16:58:37 GMT

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

Re: how to get top analysis

Thu, 16 Jan 2014 17:19:25 GMT

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

Re: how to get top analysis

jpapador — Thu, 16 Jan 2014 17:28:34 GMT

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

Re: how to get top analysis

Thu, 16 Jan 2014 17:48:48 GMT

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

Re: how to get top analysis

maxgro — Thu, 16 Jan 2014 18:03:16 GMT

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

Hope it helps you

Regards

Re: how to get top analysis

Thu, 16 Jan 2014 18:04:37 GMT

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