Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: how to get top analysis

Hi

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

Hope it helps you

Regards

6 Replies
jpapador
Valued Contributor

Re: how to get top analysis

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

Not applicable

Re: how to get top analysis

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

jpapador
Valued Contributor

Re: how to get top analysis

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

Not applicable

Re: how to get top analysis

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

MVP
MVP

Re: how to get top analysis

Hi

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

Hope it helps you

Regards

Not applicable

Re: how to get top analysis

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

Community Browser