topic Forecast data using Linest functions syntax in QlikView https://community.qlik.com/t5/QlikView/Forecast-data-using-Linest-functions-syntax/m-p/1140417#M896737 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have scenario,i need to show forecast data.</P><P>I am using linest_m and Linest_b functions and able to generate the forecasting piece</P><P></P><P><STRONG>=if(Year&lt;=2016,AVG(SalesGrowthRate),(linest_m(total aggr(if(avg(SalesGrowthRate)+$(Sales Annual Growth Rate),avg(SalesGrowthRate)+$(Sales Annual Growth Rate)),Year),Year)*Year </STRONG></P><P><STRONG>+linest_b(total aggr(if(avg(SalesGrowthRate)+$(Sales Annual Growth Rate),avg(SalesGrowthRate)+$(Sales Annual Growth Rate)),Year),Year)))</STRONG></P><P><STRONG><BR /></STRONG></P><P>But my scenario is the forecasting data is </P><P>after 2016 i want show&nbsp; <STRONG style="color: #ff9900; font-size: 13.3333px;">SalesGrowthRate</STRONG><SPAN style="color: #ff9900;">=<STRONG style="font-size: 13.3333px;">SalesGrowthRate+(<STRONG style="font-size: 13.3333px;">SalesGrowthRate*($(</STRONG></STRONG><STRONG>Sales Annual Growth Rate</STRONG></SPAN><STRONG style="color: #ff9900; font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">))</STRONG>)</STRONG></P><P></P><P>Can any body send the syntax using lineest_m and linest_b for getting the above logic</P><P></P><P>Please find the attached excel and qvw for reference</P><P></P><P>Thanks and Regards</P><P>Thiru</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Forecast data using Linest functions syntax https://community.qlik.com/t5/QlikView/Forecast-data-using-Linest-functions-syntax/m-p/1140417#M896737 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have scenario,i need to show forecast data.</P><P>I am using linest_m and Linest_b functions and able to generate the forecasting piece</P><P></P><P><STRONG>=if(Year&lt;=2016,AVG(SalesGrowthRate),(linest_m(total aggr(if(avg(SalesGrowthRate)+$(Sales Annual Growth Rate),avg(SalesGrowthRate)+$(Sales Annual Growth Rate)),Year),Year)*Year </STRONG></P><P><STRONG>+linest_b(total aggr(if(avg(SalesGrowthRate)+$(Sales Annual Growth Rate),avg(SalesGrowthRate)+$(Sales Annual Growth Rate)),Year),Year)))</STRONG></P><P><STRONG><BR /></STRONG></P><P>But my scenario is the forecasting data is </P><P>after 2016 i want show&nbsp; <STRONG style="color: #ff9900; font-size: 13.3333px;">SalesGrowthRate</STRONG><SPAN style="color: #ff9900;">=<STRONG style="font-size: 13.3333px;">SalesGrowthRate+(<STRONG style="font-size: 13.3333px;">SalesGrowthRate*($(</STRONG></STRONG><STRONG>Sales Annual Growth Rate</STRONG></SPAN><STRONG style="color: #ff9900; font-size: 13.3333px;"><STRONG style="font-size: 13.3333px;">))</STRONG>)</STRONG></P><P></P><P>Can any body send the syntax using lineest_m and linest_b for getting the above logic</P><P></P><P>Please find the attached excel and qvw for reference</P><P></P><P>Thanks and Regards</P><P>Thiru</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Forecast-data-using-Linest-functions-syntax/m-p/1140417#M896737 2020-11-25T16:16:04Z