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

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

piotrekd — Tue, 20 Mar 2018 16:30:33 GMT

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 — Tue, 20 Mar 2018 16:41:54 GMT

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 — Tue, 20 Mar 2018 16:45:52 GMT

check Liner_M() and Linear_B()

Regards,

piotrekd — Tue, 20 Mar 2018 18:37:08 GMT

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 — Wed, 31 Jul 2019 10:57:42 GMT

Hello,

have you already found a solution for this topic?

Best regards, Patrick

pwagner — Fri, 30 Aug 2019 09:54:41 GMT

Hello Piotr,

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

Best regards,

Patrick