topic Re: Top 10 rows and total of top 10 in QlikView https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332103#M1177662 <HTML><HEAD></HEAD><BODY><P>you can use this formula </P><P>in expression</P><P></P><P>If(aggr(rank(sum([Error Count])),EmployerName)&lt;=10,[Error Count])</P><P></P><P></P><P>i.e</P><P></P><P></P><P>If(aggr(rank(sum(Valuefield)),keyfield)&lt;=10,Valuefield)</P><P></P><P></P><P>hope this helps</P></BODY></HTML> Wed, 02 May 2012 13:51:38 GMT SunilChauhan 2012-05-02T13:51:38Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332099#M1177658 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>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&nbsp; as the 11th row.</P><P></P><P>Please sugeest ways to implement this.</P></BODY></HTML> Wed, 02 May 2012 12:15:23 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332099#M1177658 sonikajain 2012-05-02T12:15:23Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332100#M1177659 <HTML><HEAD></HEAD><BODY><P>In QV11 you can use Dimension Limits for top 10, then use sum of rows in expression for totals</P></BODY></HTML> Wed, 02 May 2012 12:34:21 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332100#M1177659 p_verkooijen 2012-05-02T12:34:21Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332101#M1177660 <HTML><HEAD></HEAD><BODY><P> thanks, am using qlikview 10 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /> , please suggest..</P></BODY></HTML> Wed, 02 May 2012 13:19:56 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332101#M1177660 sonikajain 2012-05-02T13:19:56Z Re: Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332102#M1177661 <HTML><HEAD></HEAD><BODY><P>see the attached file</P><P></P><P>hope this helps</P></BODY></HTML> Wed, 02 May 2012 13:49:36 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332102#M1177661 SunilChauhan 2012-05-02T13:49:36Z Re: Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332103#M1177662 <HTML><HEAD></HEAD><BODY><P>you can use this formula </P><P>in expression</P><P></P><P>If(aggr(rank(sum([Error Count])),EmployerName)&lt;=10,[Error Count])</P><P></P><P></P><P>i.e</P><P></P><P></P><P>If(aggr(rank(sum(Valuefield)),keyfield)&lt;=10,Valuefield)</P><P></P><P></P><P>hope this helps</P></BODY></HTML> Wed, 02 May 2012 13:51:38 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332103#M1177662 SunilChauhan 2012-05-02T13:51:38Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332104#M1177663 <HTML><HEAD></HEAD><BODY><P> Thanks very much Sunil...it worked, am able to fetch top 10 rows and the total of top 10.</P><P></P><P>Please help me in getting the total of remaining rows(ALL OTHERS) and the total of ALL ROWS in the same chart.</P><P>As soon as I apply the aggr function, the ALL&nbsp; OTHERS and ALL ROWS have disappeared from the chart even though I make them selected in the properties chackbox.</P><P></P><P>Please advise.</P></BODY></HTML> Wed, 02 May 2012 14:50:04 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332104#M1177663 sonikajain 2012-05-02T14:50:04Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332105#M1177664 <HTML><HEAD></HEAD><BODY><P> 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....</P></BODY></HTML> Wed, 02 May 2012 14:58:59 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332105#M1177664 sonikajain 2012-05-02T14:58:59Z Re: Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332106#M1177666 <HTML><HEAD></HEAD><BODY><P>see the attched </P><P></P><P>apply accordingly</P><P></P><P></P><P>hope this helps</P></BODY></HTML> Wed, 02 May 2012 15:04:52 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332106#M1177666 SunilChauhan 2012-05-02T15:04:52Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332107#M1177669 <HTML><HEAD></HEAD><BODY><P> am not able to open the file <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" />...can u give the settings here for ALL OTHERS and TOTAL...</P></BODY></HTML> Wed, 02 May 2012 15:16:38 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332107#M1177669 sonikajain 2012-05-02T15:16:38Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332108#M1177670 <HTML><HEAD></HEAD><BODY><P>use formula like below&nbsp; in expression for others</P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">If(aggr(rank(sum([Error Count])),EmployerName)&gt;10,[Error Count])</SPAN></P><P></P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">hope this helps<BR /></SPAN></P></BODY></HTML> Wed, 02 May 2012 15:19:28 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332108#M1177670 SunilChauhan 2012-05-02T15:19:28Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332109#M1177672 <HTML><HEAD></HEAD><BODY><P>Please help me in getting the total of remaining rows(ALL OTHERS) and the total of ALL ROWS in the same chart.</P><P>As soon as I apply the aggr function, the ALL&nbsp; OTHERS and ALL ROWS have disappeared from the chart even though I make them selected in the properties chackbox.</P></BODY></HTML> Wed, 02 May 2012 15:25:54 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332109#M1177672 sonikajain 2012-05-02T15:25:54Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332110#M1177673 <HTML><HEAD></HEAD><BODY><P>send attached sample</P></BODY></HTML> Thu, 03 May 2012 08:34:12 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332110#M1177673 SunilChauhan 2012-05-03T08:34:12Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332111#M1177675 <HTML><HEAD></HEAD><BODY><P>I am experiencing problem in opening the file ...can u please send the settings/code <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 03 May 2012 08:44:35 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332111#M1177675 sonikajain 2012-05-03T08:44:35Z Top 10 rows and total of top 10 https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332112#M1177676 <HTML><HEAD></HEAD><BODY><P>total can be achieved by&nbsp; converting pivot table into straight </P><P></P><P>then expression_&gt;sum of rows-&gt; again convert into pivot</P><P></P><P></P><P></P><P>hope this helps</P></BODY></HTML> Thu, 03 May 2012 08:48:22 GMT https://community.qlik.com/t5/QlikView/Top-10-rows-and-total-of-top-10/m-p/332112#M1177676 SunilChauhan 2012-05-03T08:48:22Z