https://community.qlik.com/t5/QlikView/Sales-Forecast/m-p/1956758#M1219937 <P>Hello, I am trying to create Sales Forecast using linear regression, but I am not sure I should change my formula.</P> <P>I have 2 expressions:</P> <P>&nbsp;sum(Sales),</P> <P>&nbsp;linest_m(total aggr(if(sum(Sales),sum(Sales)),Month),Month)*Month <BR />+linest_b(total aggr(if(sum(Sales),sum(Sales)),Month),Month)</P> <P>But in my example I don't have month number, I have combination 'month-year'. I will use 3 years of data.</P> <P>Trying to use file below for my Forecast:<BR />LOAD [Service Order Status], <BR />[Activity Month/Year], <BR />City, <BR />State, <BR />[Total Sales Count]</P> <P>Please let me know if you have any ideas how to fix it.</P> Sat, 16 Jul 2022 20:39:59 GMT RK121 2022-07-16T20:39:59Z https://community.qlik.com/t5/QlikView/Sales-Forecast/m-p/1956758#M1219937 <P>Hello, I am trying to create Sales Forecast using linear regression, but I am not sure I should change my formula.</P> <P>I have 2 expressions:</P> <P>&nbsp;sum(Sales),</P> <P>&nbsp;linest_m(total aggr(if(sum(Sales),sum(Sales)),Month),Month)*Month <BR />+linest_b(total aggr(if(sum(Sales),sum(Sales)),Month),Month)</P> <P>But in my example I don't have month number, I have combination 'month-year'. I will use 3 years of data.</P> <P>Trying to use file below for my Forecast:<BR />LOAD [Service Order Status], <BR />[Activity Month/Year], <BR />City, <BR />State, <BR />[Total Sales Count]</P> <P>Please let me know if you have any ideas how to fix it.</P> Sat, 16 Jul 2022 20:39:59 GMT https://community.qlik.com/t5/QlikView/Sales-Forecast/m-p/1956758#M1219937 RK121 2022-07-16T20:39:59Z