Discussion board where members can get started with Qlik Sense.
Can we bring the FORECAST() and TREND() functions capability in Qlik Sense ??
Thanks in Advance
Not sure what the above functions do exactly, but forecasting can be implemented using Linest_M() and Linest_B functions
Forecasting in Qlikview
View solution in original post
forecasting is not a native functonnality in qlik sense;
you have as an expression:
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:
Month(Display_Date) AS ForMonth,
Year(Display_Date) AS ForYear;
MonthStart(ADDMONTHS(TODAY(),RecNo()-1)) AS Display_Date
Month(Month_Start) AS ForMonth,
Year(Month_Start) AS ForYear,
MonthStart(ADDMONTHS(TODAY(),RecNo()-1)) AS Month_Start,
RAND()*100000 AS Revenue
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
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!!