Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)?
check Liner_M() and Linear_B()
Regards,
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.
Hello,
have you already found a solution for this topic?
Best regards, Patrick
Hello Piotr,
look the QVW attached, this is a way to solve your questions.
Let me know if this helps.
Best regards,
Patrick