Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bijoylalu007
Partner - Contributor II
Partner - Contributor II

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
sunny_talwar

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
sunny_talwar

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:

Capture.PNG

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
Contributor III
Contributor III

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
Contributor III
Contributor III

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!!