FORECAST and TREND function of Excel in Qlik Sense

[bijoylalu007]

Hi,

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

Thanks in Advance

Regards

BB

[sunny_talwar · Accepted solution]

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

Forecasting in Qlikview

[OmarBenSalem]

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:

[OmarBenSalem]

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

[Heena]

Hi,

i need to forecast for Year-Quarter-Month-Date drill down, above solution is working with respect to Month,Quarter,Date individual dates.. Need help with Drill Down!!

[Heena]

Hi,

i need to forecast for Year-Quarter-Month-Date drill down, above solution is working with respect to Month,Quarter,Date individual dates.. Need help with Drill Down!!