Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Forecast data using Linest functions syntax

Hi Guys,

I have scenario,i need to show forecast data.

I am using linest_m and Linest_b functions and able to generate the forecasting piece

=if(Year<=2016,AVG(SalesGrowthRate),(linest_m(total aggr(if(avg(SalesGrowthRate)+$(Sales Annual Growth Rate),avg(SalesGrowthRate)+$(Sales Annual Growth Rate)),Year),Year)*Year

+linest_b(total aggr(if(avg(SalesGrowthRate)+$(Sales Annual Growth Rate),avg(SalesGrowthRate)+$(Sales Annual Growth Rate)),Year),Year)))


But my scenario is the forecasting data is

after 2016 i want show  SalesGrowthRate=SalesGrowthRate+(SalesGrowthRate*($(Sales Annual Growth Rate)))

Can any body send the syntax using lineest_m and linest_b for getting the above logic

Please find the attached excel and qvw for reference

Thanks and Regards

Thiru

0 Replies