Discussion Board for collaboration related to QlikView App Development.
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,
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()
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.
have you already found a solution for this topic?
Best regards, Patrick
look the QVW attached, this is a way to solve your questions.Let me know if this helps.