topic Re: Year-End Forecast analysis in QlikView https://community.qlik.com/t5/QlikView/Year-End-Forecast-analysis/m-p/1276293#M400843 <HTML><HEAD></HEAD><BODY><P>Any help on this please?</P></BODY></HTML> Sat, 17 Dec 2016 22:57:15 GMT wossenhh 2016-12-17T22:57:15Z Year-End Forecast analysis https://community.qlik.com/t5/QlikView/Year-End-Forecast-analysis/m-p/1276292#M400842 <HTML><HEAD></HEAD><BODY><P>Hello QV guru’s,</P><P></P><P>Can you please help me out how to write the expression for Year-end Forecast that shows the selected month + forward. For e.g. since I am using a fiscal year from April to March, when a user select Dec, the calculation amount should be from Dec 2016 till March 2017.</P><P>So the calculation for YTD Forecast will be :</P><P></P><P>Sum(History_Shipment * Price_Price) + <STRONG>Sum(Forecast_Adjusted Forecast * Price) for the current month forward in time</STRONG>.</P><P></P><P>Thanks </P><P>Wossen</P></BODY></HTML> Fri, 16 Dec 2016 19:13:18 GMT https://community.qlik.com/t5/QlikView/Year-End-Forecast-analysis/m-p/1276292#M400842 wossenhh 2016-12-16T19:13:18Z Re: Year-End Forecast analysis https://community.qlik.com/t5/QlikView/Year-End-Forecast-analysis/m-p/1276293#M400843 <HTML><HEAD></HEAD><BODY><P>Any help on this please?</P></BODY></HTML> Sat, 17 Dec 2016 22:57:15 GMT https://community.qlik.com/t5/QlikView/Year-End-Forecast-analysis/m-p/1276293#M400843 wossenhh 2016-12-17T22:57:15Z