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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
0 Replies