topic Re: Projection based on Actual data in QlikView https://community.qlik.com/t5/QlikView/Projection-based-on-Actual-data/m-p/1381458#M421059 <HTML><HEAD></HEAD><BODY><P>Looks for Linest_M and Linest_B for forecast the data values</P></BODY></HTML> Fri, 08 Sep 2017 15:06:35 GMT Anil_Babu_Samineni 2017-09-08T15:06:35Z Projection based on Actual data https://community.qlik.com/t5/QlikView/Projection-based-on-Actual-data/m-p/1381457#M421058 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P>i have those data related Sales: i would like to calculate projection for the next month (Sep-oct-nov-dec) based on the actual data of the previous month. </P><P>Basically i would like to answer to the following question: based on the sales of previous months, how the sales of next month could it be?</P><P>Any idea how to implement this?</P><P>Thanks</P><P><IMG alt="QlikGraph.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/175962_QlikGraph.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 08 Sep 2017 14:58:29 GMT https://community.qlik.com/t5/QlikView/Projection-based-on-Actual-data/m-p/1381457#M421058 qlikviewaf 2017-09-08T14:58:29Z Re: Projection based on Actual data https://community.qlik.com/t5/QlikView/Projection-based-on-Actual-data/m-p/1381458#M421059 <HTML><HEAD></HEAD><BODY><P>Looks for Linest_M and Linest_B for forecast the data values</P></BODY></HTML> Fri, 08 Sep 2017 15:06:35 GMT https://community.qlik.com/t5/QlikView/Projection-based-on-Actual-data/m-p/1381458#M421059 Anil_Babu_Samineni 2017-09-08T15:06:35Z