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

[piotrekd]

Hi,

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

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

[wdchristensen]

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,

[piotrekd]

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

QVW file is in my previous post.

[pwagner]

Hello,

have you already found a solution for this topic?

Best regards, Patrick

[pwagner]

Hello Piotr,

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

Best regards, 

Patrick