# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Not applicable

## Top n data

1st table

 Airport Revenue in US\$ Flights Grand Total 57,732,036,757 1,068,164 Maya-Maya Airport 24,082,856,986 467,982 Asmara International Airport 16,156,464,665 280,323 Cairo International Airport 10,150,200,885 188,215 Tripoli International Airport 3,460,486,572 48,468 Cape Town International Airport 2,335,975,371 44,474 Calgary International Airport 772,424,866 14,234 Vancouver International Airport 505,395,812 11,452 Ontario International Airport 268,231,601 13,016

2nd table extracted from 1st table(Top 3 Airports)

 Airport Revenue in US\$ Flights Grand Total 50,389,522,535 936,520 Maya-Maya Airport 24,082,856,986 467,982 Asmara International Airport 16,156,464,665 280,323 Cairo International Airport 10,150,200,885 188,215

I am having problem in acquiring the result of 2nd table. Can anyone help me? I want to see any top n airports with revenue & flight detail as mentioned in the 2nd table.

Tags (1)
8 Replies
Honored Contributor II

## Re: Top n data

hi

try this

dimesnison limits-> largest 3 value and dont show  others

will this work for you ?

regards

Learning never stops.
Not applicable

## Re: Top n data

I do not want to use dim limits as I have already used variable vCounter which varies from 0 to 8 where 0 means all airports & remaining numbers for top n. I actually need to know the exact expression to be used for both revenue & flights in case of all or top n.

Honored Contributor II

## Re: Top n data

You can use the variable in place of that number something like =\$( vCounter) iin the expression. It will be the simplest solution for you.

Learning never stops.
Not applicable

## Re: Top n data

I need to know the exact expression to be used for the issue.

Honored Contributor II

## Re: Top n data

can you share your sample app? Please try using =\$(variablename ) in the dimensionlimit tab to show the top n value.

Learning never stops.
Honored Contributor

## Re: Top n data

Aggr(if(Rank(Sum(Revenue),1,1) <=3,Airport),Airport)

In a straight table check the Suppress When Value Is Null checkbox.

Regards

Andrew

Not applicable

## Re: Top n data

The problem exists in expression tab not in dimension. I need to know exact expression to be used for top n.

Honored Contributor