Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

FORECAST and TREND function from Excel (how to count?)

Hi,

I have to calculate forecast values similar to excel FORECAST() & TREND() functions:

Excel_Trend_Forecast.PNG

I've attached QVW file with above data (actual) & my attempt to get value for July.


Are there equivalent functions to calculate this in QV/QS?

In my approach I want to calculate it permanently in ETL to have it directly in data model.


Thanks in advance,

Piotr





5 Replies
Highlighted
Valued Contributor

Re: FORECAST and TREND function from Excel (how to count?)

https://www.packtpub.com/sites/default/files/downloads/5803EN_ColorImages.pdf

This looks similar to the information from Ferran Garcia Parans book Predictive Analytics Using Rattle and Qlik Sense.

What is your datasource (what type of database)?

Highlighted

Re: FORECAST and TREND function from Excel (how to count?)

check Liner_M() and Linear_B()

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Partner
Partner

Re: FORECAST and TREND function from Excel (how to count?)

I've tried to use Linest_M & Linest_B in many combinations according to community topics, but without result:

Linest_M Linest_B.png

QVW file is in my previous post.

Highlighted
Partner
Partner

Re: FORECAST and TREND function from Excel (how to count?)

Hello,

have you already found a solution for this topic?

 

Best regards, Patrick

Highlighted
Partner
Partner

Re: FORECAST and TREND function from Excel (how to count?)

Hello Piotr,

look the QVW attached, this is a way to solve your questions.
Let me know if this helps.

 

Best regards, 

Patrick