Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Reuven12
Contributor II
Contributor II

Forecast by Progress

Hey all,

I have an issue I don't know how to resault.

I have a sales table that includes data between 01/01/2010 and 31/03/2010 

and I want to create a forecast for the months April to December.

how can I do it? I tried with linest_m but it only gives me one month ahead.

that's my table:

LOAD
CustomerID,
year(OrderDate) as Year,
month (OrderDate) as Month,
OrderDate ,
OrderID,
ProductID,
AMOUNT as Amount,
CANCEL_FLAG
Resident Sales

Thank you.

0 Replies