Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Partner
Partner

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
Highlighted

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

View solution in original post

5 Replies
Highlighted

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

View solution in original post

Partner
Partner

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

Highlighted
Partner
Partner

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

Highlighted
Heena
New Contributor III

Re: FORECAST and TREND function of Excel in 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!!

Highlighted
Heena
New Contributor III

Re: FORECAST and TREND function of Excel in 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!!