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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
RK121
Contributor III
Contributor III

Sales Forecast

Hello, I am trying to create Sales Forecast using linear regression, but I am not sure I should change my formula.

I have 2 expressions:

 sum(Sales),

 linest_m(total aggr(if(sum(Sales),sum(Sales)),Month),Month)*Month
+linest_b(total aggr(if(sum(Sales),sum(Sales)),Month),Month)

But in my example I don't have month number, I have combination 'month-year'. I will use 3 years of data.

Trying to use file below for my Forecast:
LOAD [Service Order Status],
[Activity Month/Year],
City,
State,
[Total Sales Count]

Please let me know if you have any ideas how to fix it.

0 Replies