topic Re: Linear regression for forecasting data in QlikView

Linear regression for forecasting data

Wed, 25 Nov 2020 16:16:04 GMT

i have scenario,i want to show forecasting data for another 20 years

so my dates are 2005 to 2035

sales growth rate is from 2005 to 2016 available. want to show from 2016 it need to change based on sales growth rate variable

My expression is

=if([Fiscal Year]<=2016,AVG(Sales),linest_m(total aggr(if(avg(Sales),avg(Sales),[Fiscal Year]),[Fiscal Year])*[Fiscal Year]

+linest_b(total aggr(if(avg(Sales),avg(Sales)),[Fiscal Year]),[Fiscal Year])

Please suggest me if variable name is 'sales growth rate' then where i need to put this in the above formula.

Please find the attached document for reference

Thanks

Thiru

Re: Linear regression for forecasting data

jonathandienst — Fri, 10 Jun 2016 08:08:46 GMT

Your requirement is not clear. I suggest that you post a sample qvw to help to show what you have and then explain clearly what you would like to do with this variable.

Re: Linear regression for forecasting data

Fri, 10 Jun 2016 09:19:50 GMT

Please click the below link,beacuse i am not able to add my sample qvw here

foercast using linear function

Thiru