Qlik Sense How to do Forecasting?

[#1]

Hi All,

Can someone tell how to do forecasting line chart for some financial data.

Thanks in advance.

[#2]

I used:

if(SUM(Revenue),SUM(Revenue),

linest_m(total aggr(if(SUM(Revenue),SUM(Revenue)),Date),Date)* 

only({1}Date)

+linest_b(total aggr(if(SUM(Revenue),SUM(Revenue)),Date),Date))

which uses the very simple y=mx+b to calculate the straight line. If you project your [Date] forward, the line will be projected forward as well.

This created a set "MMM-YYYY" of 12 months behind, 3 months ahead:

Let varMinDate = Num(MonthStart(AddMonths(Today(),-12)));

TempCalendar:

LOAD

               Date(AddMonths($(varMinDate), + RecNo() - 1),'MMM-YYYY') as Date

AutoGenerate 15;

[#3]

Hi,

Go through the below attached qvw files it might help u.