topic AGGR problem in QlikView https://community.qlik.com/t5/QlikView/AGGR-problem/m-p/202439#M60142 <HTML><HEAD></HEAD><BODY><P>This should be easy...</P><P></P><P>I'm trying to create a line chart which simply takes the last Stock entry to date. Somehow it doesn't aggregates properlly.</P><P>The reason i've used date island is that the client want to see inventory stand to date even though there were no transactions in that date.</P><P>Chart type: Line chart</P><P>Dimmension: Year, MonthYear, Date</P><P>Expression:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR /><BR />=Aggr(<BR /> max(<BR /> if([Inventory Date] &lt;=aggr(max(Date),Date) and [Inventory Next Date] &gt; aggr(max(Date),Date), [Inventory Stock Qty],0<BR /> )<BR /> ),<BR /> Date<BR /> )<BR /></PRE><BR /><BR /> <P></P><P>Ive attached file as example.</P><P></P><P></P></BODY></HTML> Thu, 07 Apr 2011 09:31:40 GMT 2011-04-07T09:31:40Z AGGR problem https://community.qlik.com/t5/QlikView/AGGR-problem/m-p/202439#M60142 <HTML><HEAD></HEAD><BODY><P>This should be easy...</P><P></P><P>I'm trying to create a line chart which simply takes the last Stock entry to date. Somehow it doesn't aggregates properlly.</P><P>The reason i've used date island is that the client want to see inventory stand to date even though there were no transactions in that date.</P><P>Chart type: Line chart</P><P>Dimmension: Year, MonthYear, Date</P><P>Expression:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR /><BR />=Aggr(<BR /> max(<BR /> if([Inventory Date] &lt;=aggr(max(Date),Date) and [Inventory Next Date] &gt; aggr(max(Date),Date), [Inventory Stock Qty],0<BR /> )<BR /> ),<BR /> Date<BR /> )<BR /></PRE><BR /><BR /> <P></P><P>Ive attached file as example.</P><P></P><P></P></BODY></HTML> Thu, 07 Apr 2011 09:31:40 GMT https://community.qlik.com/t5/QlikView/AGGR-problem/m-p/202439#M60142 2011-04-07T09:31:40Z