topic Re: Showing first n records in QlikView https://community.qlik.com/t5/QlikView/Showing-first-n-records/m-p/672284#M244173 <HTML><HEAD></HEAD><BODY><P>Try (replacing City and Quantity with your field names):</P><P></P><P>=sum({&lt;City = {"=rank(sum(Quantity))&lt;=20"}&gt;} Quantity)</P></BODY></HTML> Sat, 28 Jun 2014 08:32:16 GMT swuehl 2014-06-28T08:32:16Z Showing first n records https://community.qlik.com/t5/QlikView/Showing-first-n-records/m-p/672283#M244172 <HTML><HEAD></HEAD><BODY><P>Hi All,'</P><P>Can you please suggest</P><P>how to show sum of quantity for first 20 city using rank function.</P><P></P><P></P><P>Thanks </P></BODY></HTML> Sat, 28 Jun 2014 08:24:58 GMT https://community.qlik.com/t5/QlikView/Showing-first-n-records/m-p/672283#M244172 deepakqlikview_123 2014-06-28T08:24:58Z Re: Showing first n records https://community.qlik.com/t5/QlikView/Showing-first-n-records/m-p/672284#M244173 <HTML><HEAD></HEAD><BODY><P>Try (replacing City and Quantity with your field names):</P><P></P><P>=sum({&lt;City = {"=rank(sum(Quantity))&lt;=20"}&gt;} Quantity)</P></BODY></HTML> Sat, 28 Jun 2014 08:32:16 GMT https://community.qlik.com/t5/QlikView/Showing-first-n-records/m-p/672284#M244173 swuehl 2014-06-28T08:32:16Z Re: Showing first n records https://community.qlik.com/t5/QlikView/Showing-first-n-records/m-p/672285#M244174 <HTML><HEAD></HEAD><BODY><P>For simple way.. You can use Dimension Limit "Largest" 20.</P></BODY></HTML> Sat, 28 Jun 2014 08:33:25 GMT https://community.qlik.com/t5/QlikView/Showing-first-n-records/m-p/672285#M244174 selvakumarsr 2014-06-28T08:33:25Z Re: Showing first n records https://community.qlik.com/t5/QlikView/Showing-first-n-records/m-p/672286#M244175 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=aggr(if(Rank(total Sum(Quantity)=20, DimensionColumnName), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DimensionColumnName</SPAN>)</SPAN></P></BODY></HTML> Sat, 28 Jun 2014 08:36:14 GMT https://community.qlik.com/t5/QlikView/Showing-first-n-records/m-p/672286#M244175 selvakumarsr 2014-06-28T08:36:14Z