Qlik Sense How to do Forecasting?

Tue, 20 Oct 2015 11:34:43 GMT

Hi All,

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

Thanks in advance.

Re: Qlik Sense How to do Forecasting?

Tue, 20 Oct 2015 12:14:58 GMT

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;

Tue, 20 Oct 2015 12:19:21 GMT

Hi,

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