topic Re: need help on aggr()!! in QlikView https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898716#M1000607 <HTML><HEAD></HEAD><BODY><P>yes that's exactly am looking for and thanks petter for your quick response.!</P></BODY></HTML> Tue, 02 Jun 2015 20:05:05 GMT satishqlik 2015-06-02T20:05:05Z need help on aggr()!! https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898714#M1000603 <HTML><HEAD></HEAD><BODY><P>Hello Viewers,</P><P></P><P>I want to show only year wise top performers of the last 5yrs.</P><P></P><P>So my output would be like this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="20" width="64">eid</TD><TD width="64">nam</TD><TD width="64">yr1</TD><TD width="64">sal1</TD></TR><TR><TD align="right" height="20">1</TD><TD>a</TD><TD align="right">2010</TD><TD align="right">600</TD></TR><TR><TD align="right" height="20">2</TD><TD>b</TD><TD align="right">2011</TD><TD align="right">900</TD></TR><TR><TD align="right" height="20">3</TD><TD>c</TD><TD align="right">2012</TD><TD align="right">1200</TD></TR><TR><TD align="right" height="20">4</TD><TD>d</TD><TD align="right">2013</TD><TD align="right">1500</TD></TR><TR><TD align="right" height="20">5</TD><TD>e</TD><TD align="right">2014</TD><TD align="right">1800</TD></TR></TBODY></TABLE><P></P><P></P><P>attached below xl for your reference.</P><P></P><P>Plz suggest how can I achieve this?</P><P></P><P>Any advice would be appreciated. Thanks in advance!!!</P></BODY></HTML> Tue, 02 Jun 2015 19:26:25 GMT https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898714#M1000603 satishqlik 2015-06-02T19:26:25Z Re: need help on aggr()!! https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898715#M1000605 <HTML><HEAD></HEAD><BODY><P>You don't need Aggr() for this one.</P><P></P><P>Just have:</P><P></P><P>dimension:&nbsp;&nbsp;&nbsp;&nbsp; yr1</P><P>expression 1: Max(sal1)</P><P>expression 2: FirstSortedValue( name, -sal1 )</P><P></P><P>In a straight table.</P></BODY></HTML> Tue, 02 Jun 2015 19:39:49 GMT https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898715#M1000605 petter 2015-06-02T19:39:49Z Re: need help on aggr()!! https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898716#M1000607 <HTML><HEAD></HEAD><BODY><P>yes that's exactly am looking for and thanks petter for your quick response.!</P></BODY></HTML> Tue, 02 Jun 2015 20:05:05 GMT https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898716#M1000607 satishqlik 2015-06-02T20:05:05Z Re: need help on aggr()!! https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898717#M1000608 <HTML><HEAD></HEAD><BODY><P>happy to be of help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 02 Jun 2015 20:07:06 GMT https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898717#M1000608 petter 2015-06-02T20:07:06Z Re: need help on aggr()!! https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898718#M1000609 <HTML><HEAD></HEAD><BODY><P>sum({&lt;numyear={"&gt;=$(=Max(numyear -4))&lt;=$(=Max(numyear))"}&gt;}sales)</P><P>it should be your requirement try it once</P></BODY></HTML> Wed, 03 Jun 2015 04:21:50 GMT https://community.qlik.com/t5/QlikView/need-help-on-aggr/m-p/898718#M1000609 pratap6699 2015-06-03T04:21:50Z