Top 10 rows and total of top 10

[sonikajain]

Dear all,

I need to implement a straight table where the top 10 rows based upon a particular measure are to be displayed, and then the total of the top 10 rows  as the 11th row.

Please sugeest ways to implement this.

[p_verkooijen]

In QV11 you can use Dimension Limits for top 10, then use sum of rows in expression for totals

[sonikajain]

thanks, am using qlikview 10 , please suggest..

[SunilChauhan]

see the attached file

hope this helps

[SunilChauhan]

you can use this formula

in expression

If(aggr(rank(sum([Error Count])),EmployerName)<=10,[Error Count])

i.e

If(aggr(rank(sum(Valuefield)),keyfield)<=10,Valuefield)

hope this helps

[sonikajain]

Thanks very much Sunil...it worked, am able to fetch top 10 rows and the total of top 10.

Please help me in getting the total of remaining rows(ALL OTHERS) and the total of ALL ROWS in the same chart.

As soon as I apply the aggr function, the ALL  OTHERS and ALL ROWS have disappeared from the chart even though I make them selected in the properties chackbox.

Please advise.

[sonikajain]

hey..this s giving me lowest 10 rows....can u please help me getting the TOP 10 in descending order....the data coming from load scritp is not ordered..and I cannot touch that too....

[SunilChauhan]

see the attched

apply accordingly

hope this helps

[sonikajain]

am not able to open the file ...can u give the settings here for ALL OTHERS and TOTAL...

[SunilChauhan]

use formula like below  in expression for others

If(aggr(rank(sum([Error Count])),EmployerName)>10,[Error Count])

hope this helps