Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can we bring the FORECAST() and TREND() functions capability in Qlik Sense ??
Thanks in Advance
Regards
BB
Not sure what the above functions do exactly, but forecasting can be implemented using Linest_M() and Linest_B functions
Not sure what the above functions do exactly, but forecasting can be implemented using Linest_M() and Linest_B functions
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:
Or refer to this (advanced analytics on qlik sense) or how to integrate R and python functionnalities to qlik sense:
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!!