topic Re: reg-var in QlikView https://community.qlik.com/t5/QlikView/reg-var/m-p/641081#M234862 <HTML><HEAD></HEAD><BODY><P>Check this</P></BODY></HTML> Wed, 21 May 2014 06:37:52 GMT anbu1984 2014-05-21T06:37:52Z reg-var https://community.qlik.com/t5/QlikView/reg-var/m-p/641078#M234859 <HTML><HEAD></HEAD><BODY><P>1.<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;"> can u say one thing if i have 100 records and i want to display top 5 records and low 5 records</SPAN></P></BODY></HTML> Wed, 21 May 2014 06:24:20 GMT https://community.qlik.com/t5/QlikView/reg-var/m-p/641078#M234859 2014-05-21T06:24:20Z Re: reg-var https://community.qlik.com/t5/QlikView/reg-var/m-p/641079#M234860 <HTML><HEAD></HEAD><BODY><P>You might have to use rank() alongwith aggr(). Sample qvw could help me help you.</P></BODY></HTML> Wed, 21 May 2014 06:28:37 GMT https://community.qlik.com/t5/QlikView/reg-var/m-p/641079#M234860 tresB 2014-05-21T06:28:37Z Re: reg-var https://community.qlik.com/t5/QlikView/reg-var/m-p/641080#M234861 <HTML><HEAD></HEAD><BODY><P>sum({&lt;Dimension={'=sum(aggr(rank(sum([BASIC AMOUNT]))&lt;6,Dimension))'}&gt;}[BASIC AMOUNT])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; top 5</P><P>sum({&lt;Dimension={'=sum(aggr(rank(-sum([BASIC AMOUNT]))&lt;6,Dimension))'}&gt;}[BASIC AMOUNT])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bottom 5</P></BODY></HTML> Wed, 21 May 2014 06:37:16 GMT https://community.qlik.com/t5/QlikView/reg-var/m-p/641080#M234861 preminqlik 2014-05-21T06:37:16Z Re: reg-var https://community.qlik.com/t5/QlikView/reg-var/m-p/641081#M234862 <HTML><HEAD></HEAD><BODY><P>Check this</P></BODY></HTML> Wed, 21 May 2014 06:37:52 GMT https://community.qlik.com/t5/QlikView/reg-var/m-p/641081#M234862 anbu1984 2014-05-21T06:37:52Z