Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Qlik Sense How to do Forecasting?

Hi All,

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

Thanks in advance.

2 Replies
Not applicable

Re: Qlik Sense How to do Forecasting?

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;

Not applicable

Re: Qlik Sense How to do Forecasting?

Hi,

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

Community Browser