# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Partner

## FORECAST and TREND function of Excel in Qlik Sense

Hi,

Can we bring the FORECAST() and TREND() functions capability in Qlik Sense ??

Regards

BB

1 Solution

Accepted Solutions
Highlighted
MVP

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

5 Replies
Highlighted
MVP

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

Highlighted
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:

Display_Date,

Month(Display_Date) AS ForMonth,

Year(Display_Date) AS ForYear;

AUTOGENERATE 36;

Random_Finance:

Month(Month_Start) AS ForMonth,

Year(Month_Start) AS ForYear,

Revenue;

RAND()*100000 AS Revenue

AUTOGENERATE 12;

result:

Highlighted
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:

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