topic Re: Aggr function problem !!! in QlikView https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/839472#M295085 <HTML><HEAD></HEAD><BODY><P>try with (and check it!)</P><P>Sum({$&lt; AÑO=, MES= , Date = {"&lt;=$(=DATE(MonthEnd(Max(Date))))"}&nbsp;&nbsp; &gt;} </P><P>Aggr(SUM( {$&lt; AÑO=, MES= , Date = {"&lt;=$(=DATE(MonthEnd(Max(Date))))"}&nbsp;&nbsp; &gt;} </P><P>Sales ),Group, Id, Description,Type))</P></BODY></HTML> Fri, 05 Jun 2015 20:07:28 GMT maxgro 2015-06-05T20:07:28Z Aggr function problem !!! https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/839471#M295084 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I encounter a problem in using aggr. Hope someone can give me some help, much appreciate!</P><P></P><P><IMG alt="Imagen1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88527_Imagen1.png" style="height: 67px; width: 620px;" /></P><P></P><P><SPAN lang="en"><SPAN class="hps">How</SPAN> <SPAN class="hps">do I get</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">first</SPAN> <SPAN class="hps">expression of</SPAN> <SPAN class="hps">the same result as</SPAN> <SPAN class="hps">the second expression?<BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">Attached Example&nbsp; Aggr.qvw</SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"></SPAN></SPAN>PS: <SPAN lang="en"><SPAN class="hps">Sorry for my English</SPAN></SPAN><BR /></SPAN></SPAN></P></BODY></HTML> Fri, 05 Jun 2015 19:34:44 GMT https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/839471#M295084 2015-06-05T19:34:44Z Re: Aggr function problem !!! https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/839472#M295085 <HTML><HEAD></HEAD><BODY><P>try with (and check it!)</P><P>Sum({$&lt; AÑO=, MES= , Date = {"&lt;=$(=DATE(MonthEnd(Max(Date))))"}&nbsp;&nbsp; &gt;} </P><P>Aggr(SUM( {$&lt; AÑO=, MES= , Date = {"&lt;=$(=DATE(MonthEnd(Max(Date))))"}&nbsp;&nbsp; &gt;} </P><P>Sales ),Group, Id, Description,Type))</P></BODY></HTML> Fri, 05 Jun 2015 20:07:28 GMT https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/839472#M295085 maxgro 2015-06-05T20:07:28Z Re: Aggr function problem !!! https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/839473#M295086 <HTML><HEAD></HEAD><BODY><P class="g-unit"><SPAN class="short_text" lang="en"><SPAN class="hps">Excellent</SPAN> <SPAN class="hps">!!</SPAN></SPAN></P><P class="g-unit"><SPAN class="short_text" lang="en"><SPAN class="hps"></SPAN> T<SPAN class="hps">hank you very much</SPAN></SPAN></P></BODY></HTML> Fri, 05 Jun 2015 20:20:43 GMT https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/839473#M295086 2015-06-05T20:20:43Z