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: 
piotrekd
Partner - Contributor II
Partner - Contributor II

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
wdchristensen
Specialist
Specialist

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)?

PrashantSangle

check Liner_M() and Linear_B()

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
piotrekd
Partner - Contributor II
Partner - Contributor II
Author

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.

pwagner
Partner - Creator III
Partner - Creator III

Hello,

have you already found a solution for this topic?

 

Best regards, Patrick

pwagner
Partner - Creator III
Partner - Creator III

Hello Piotr,

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

 

Best regards, 

Patrick