topic Re: Can anyone help in QlikView https://community.qlik.com/t5/QlikView/Can-anyone-help/m-p/524220#M1143178 <HTML><HEAD></HEAD><BODY><P>Better you calculate this in the script.</P><P>Aggregate the stock monthly and then sort it month wise, then use peek function to formulate the opening stock.</P><P></P><P>Something Like:</P><P>MonthlyStock:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MonthlyStock,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Peek(MonthlyStock) as OpeningStock;</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(Stock) as MonthlyStock,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month</P><P>From &lt;&gt; group by Month Order By Month;</P></BODY></HTML> Fri, 23 Aug 2013 11:51:45 GMT tresB 2013-08-23T11:51:45Z Can anyone help https://community.qlik.com/t5/QlikView/Can-anyone-help/m-p/524219#M1143177 <HTML><HEAD></HEAD><BODY><P>In my attached model , why the opening stock expression is not working?</P><P></P><P>the above() functions is not working .</P><P></P><P></P><P></P><P>I want the output as this :</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; July 2013&nbsp;&nbsp;&nbsp; Aug 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sep 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Oct2013</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Opening Stock&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Closing Stock&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P></BODY></HTML> Fri, 23 Aug 2013 11:31:34 GMT https://community.qlik.com/t5/QlikView/Can-anyone-help/m-p/524219#M1143177 suvechha_b 2013-08-23T11:31:34Z Re: Can anyone help https://community.qlik.com/t5/QlikView/Can-anyone-help/m-p/524220#M1143178 <HTML><HEAD></HEAD><BODY><P>Better you calculate this in the script.</P><P>Aggregate the stock monthly and then sort it month wise, then use peek function to formulate the opening stock.</P><P></P><P>Something Like:</P><P>MonthlyStock:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MonthlyStock,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Peek(MonthlyStock) as OpeningStock;</P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(Stock) as MonthlyStock,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month</P><P>From &lt;&gt; group by Month Order By Month;</P></BODY></HTML> Fri, 23 Aug 2013 11:51:45 GMT https://community.qlik.com/t5/QlikView/Can-anyone-help/m-p/524220#M1143178 tresB 2013-08-23T11:51:45Z