13 Replies Latest reply: May 3, 2012 4:48 AM by Sunil Chauhan

# Top 10 rows and total of top 10

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.

• ###### Top 10 rows and total of top 10

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

• ###### Top 10 rows and total of top 10

thanks, am using qlikview 10 , please suggest..

• ###### Re: Top 10 rows and total of top 10

see the attached file

hope this helps

• ###### Re: Top 10 rows and total of top 10

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

• ###### Top 10 rows and total of top 10

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.

• ###### Top 10 rows and total of top 10

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

• ###### Re: Top 10 rows and total of top 10

see the attched

apply accordingly

hope this helps

• ###### Top 10 rows and total of top 10

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

• ###### Top 10 rows and total of top 10

use formula like below  in expression for others

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

hope this helps

• ###### Top 10 rows and 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.

• ###### Top 10 rows and total of top 10

send attached sample

• ###### Top 10 rows and total of top 10

I am experiencing problem in opening the file ...can u please send the settings/code

• ###### Top 10 rows and total of top 10

total can be achieved by  converting pivot table into straight

then expression_>sum of rows-> again convert into pivot

hope this helps