
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure what the above functions do exactly, but forecasting can be implemented using Linest_M() and Linest_B functions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure what the above functions do exactly, but forecasting can be implemented using Linest_M() and Linest_B functions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or refer to this (advanced analytics on qlik sense) or how to integrate R and python functionnalities to qlik sense:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!!
