topic Re: Top n data in QlikView

Top n data

Mon, 16 Oct 2017 05:23:21 GMT

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.

Re: Top n data

pradosh_thakur — Mon, 16 Oct 2017 05:53:44 GMT

try this

dimesnison limits-> largest 3 value and dont show others

will this work for you ?

regards

Pradosh

Re: Top n data

Mon, 16 Oct 2017 06:28:02 GMT

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.

Re: Top n data

pradosh_thakur — Mon, 16 Oct 2017 06:47:48 GMT

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

Re: Top n data

Mon, 16 Oct 2017 07:03:51 GMT

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

Re: Top n data

pradosh_thakur — Mon, 16 Oct 2017 07:06:44 GMT

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

Re: Top n data

effinty2112 — Mon, 16 Oct 2017 07:32:10 GMT

Hi Arshad,

Try this as your dimension:

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

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

Regards

Andrew

Re: Top n data

Mon, 16 Oct 2017 08:50:47 GMT

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

Re: Top n data

effinty2112 — Mon, 16 Oct 2017 09:08:21 GMT

Hi Arshad,

Have you tried the calculated dimension? It will give you the top 3 in a straight table.

Regards

Andrew