Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bijoylalu007
New Contributor II

FORECAST and TREND function of Excel in Qlik Sense

Hi,

Can we bring the FORECAST() and TREND() functions capability in Qlik Sense ??

Thanks in Advance

Regards

BB

1 Solution

Accepted Solutions
MVP
MVP

Re: FORECAST and TREND function of Excel in Qlik Sense

Not sure what the above functions do exactly, but forecasting can be implemented using Linest_M() and Linest_B functions

Forecasting in Qlikview

3 Replies
MVP
MVP

Re: FORECAST and TREND function of Excel in Qlik Sense

Not sure what the above functions do exactly, but forecasting can be implemented using Linest_M() and Linest_B functions

Forecasting in Qlikview

omarbensalem
Esteemed Contributor

Re: FORECAST and TREND function of Excel in Qlik Sense

forecasting is not a native functonnality in qlik sense;

but suppose:

you have as an expression:

Sum(Revenue)

to forecast it:

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

only(Display_Date) +linest_b(total aggr(if(SUM(Revenue),SUM(Revenue)),Display_Date),Display_Date))



as a dimension :Display_Date

and add this to ur script:

Trend_Dates:

LOAD

Display_Date,

    Month(Display_Date) AS ForMonth,

    Year(Display_Date) AS ForYear;

LOAD

MonthStart(ADDMONTHS(TODAY(),RecNo()-1)) AS Display_Date

AUTOGENERATE 36;

Random_Finance:

LOAD

Month(Month_Start) AS ForMonth,

    Year(Month_Start) AS ForYear,

    Revenue;

LOAD

MonthStart(ADDMONTHS(TODAY(),RecNo()-1)) AS Month_Start,

    RAND()*100000 AS Revenue

AUTOGENERATE 12;


result:

Capture.PNG

omarbensalem
Esteemed Contributor

Re: FORECAST and TREND function of Excel in Qlik Sense

Or refer to this (advanced analytics on qlik sense) or how to integrate R and python functionnalities to qlik sense:

Introducing Qlik Advanced Analytics Integration