topic How to select top 5 data from a dataset in QlikView https://community.qlik.com/t5/QlikView/How-to-select-top-5-data-from-a-dataset/m-p/351740#M577565 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try with rank function</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum({&lt;Drugs={"=Rank(Sum(Sales))&lt;=10"}&gt;} Sales)</P><P>Or</P><P>=IF(AGGR(RANK(SUM(Sales)), Drugs) &lt;= 10, SUM(Sales))</P><P></P><P>Celambarasan</P></BODY></HTML> Wed, 14 Mar 2012 07:55:01 GMT CELAMBARASAN 2012-03-14T07:55:01Z How to select top 5 data from a dataset https://community.qlik.com/t5/QlikView/How-to-select-top-5-data-from-a-dataset/m-p/351739#M577564 <HTML><HEAD></HEAD><BODY><P>Hey People,</P><P></P><P>I want to create a table containing top 5 say 'drugs' based on total sales..How do i do that without making any change in the database?</P></BODY></HTML> Wed, 14 Mar 2012 07:45:43 GMT https://community.qlik.com/t5/QlikView/How-to-select-top-5-data-from-a-dataset/m-p/351739#M577564 2012-03-14T07:45:43Z How to select top 5 data from a dataset https://community.qlik.com/t5/QlikView/How-to-select-top-5-data-from-a-dataset/m-p/351740#M577565 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try with rank function</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum({&lt;Drugs={"=Rank(Sum(Sales))&lt;=10"}&gt;} Sales)</P><P>Or</P><P>=IF(AGGR(RANK(SUM(Sales)), Drugs) &lt;= 10, SUM(Sales))</P><P></P><P>Celambarasan</P></BODY></HTML> Wed, 14 Mar 2012 07:55:01 GMT https://community.qlik.com/t5/QlikView/How-to-select-top-5-data-from-a-dataset/m-p/351740#M577565 CELAMBARASAN 2012-03-14T07:55:01Z