topic Forecast report in QlikView https://community.qlik.com/t5/QlikView/Forecast-report/m-p/442428#M699049 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I am trying to build up an inventory forecast report. I have three tables: there is current stock level in one, demand forecast in one (--&gt;decrease inventory) and planned production orders (--&gt; increase inventory). Demand forecast and planned production orders are by period. </P><P></P><P>What kind of script I need to come up with periodic inventories. (current inventory + cumulative production orders - cumulative demand)? Please see the example below.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Current period</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Period 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Period 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Period 3</STRONG></SPAN></TH></TR><TR><TD>Beginning inventory</TD><TD style="text-align: center;">5000</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>Demand</TD><TD></TD><TD style="text-align: center;">-2000</TD><TD style="text-align: center;">-3000</TD><TD style="text-align: center;">-1000</TD></TR><TR><TD>Production </TD><TD></TD><TD style="text-align: center;">0</TD><TD style="text-align: center;">5000</TD><TD style="text-align: center;">0</TD></TR><TR><TD><STRONG>Periodic inventory</STRONG></TD><TD></TD><TD style="text-align: center;"><STRONG>3000</STRONG></TD><TD style="text-align: center;"><STRONG>5000</STRONG></TD><TD style="text-align: center;"><STRONG>4000</STRONG></TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks already beforehand!</P><P></P><P>Regards</P><P>Janne</P></BODY></HTML> Mon, 17 Dec 2012 13:37:40 GMT 2012-12-17T13:37:40Z Forecast report https://community.qlik.com/t5/QlikView/Forecast-report/m-p/442428#M699049 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I am trying to build up an inventory forecast report. I have three tables: there is current stock level in one, demand forecast in one (--&gt;decrease inventory) and planned production orders (--&gt; increase inventory). Demand forecast and planned production orders are by period. </P><P></P><P>What kind of script I need to come up with periodic inventories. (current inventory + cumulative production orders - cumulative demand)? Please see the example below.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Current period</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Period 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Period 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Period 3</STRONG></SPAN></TH></TR><TR><TD>Beginning inventory</TD><TD style="text-align: center;">5000</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>Demand</TD><TD></TD><TD style="text-align: center;">-2000</TD><TD style="text-align: center;">-3000</TD><TD style="text-align: center;">-1000</TD></TR><TR><TD>Production </TD><TD></TD><TD style="text-align: center;">0</TD><TD style="text-align: center;">5000</TD><TD style="text-align: center;">0</TD></TR><TR><TD><STRONG>Periodic inventory</STRONG></TD><TD></TD><TD style="text-align: center;"><STRONG>3000</STRONG></TD><TD style="text-align: center;"><STRONG>5000</STRONG></TD><TD style="text-align: center;"><STRONG>4000</STRONG></TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks already beforehand!</P><P></P><P>Regards</P><P>Janne</P></BODY></HTML> Mon, 17 Dec 2012 13:37:40 GMT https://community.qlik.com/t5/QlikView/Forecast-report/m-p/442428#M699049 2012-12-17T13:37:40Z