Hi Seniors,
I am new to Qlikview and trying to explore QV based on current project requirement.
While working on one such request I came across analytical model that I have to implement using qlikview.
It looks like Linear equation in the form of Y = B0 +B1.x ( Where B0and B1 calculated using below method)
X Y Mean(x) (X-Mx) (Y-My) (X-Mx) * (Y-My)
2001 10 2002 -1 -5 5
2002 14 2002 0 -1 0
2003 16 2002 1 1 1
I am able to calculate Values in Tabular form, However I am not able to calculate these values in Variable using Sum as I want the Sum of above calculated columns. e.g. SUM(X-Mx) , Sum(Y-My) and Sum((X-Mx)*(Y-My)) and Sum of Squares of (X-Mx) values.
I want these values so that I can calculate the coefficient and predict values of any Future X values and get its corrosponding Y values.
Please let me know in case if you need any further details from my side.
I know it much Tricky , however while going through your blogs it feels that you can help on this or atleaset guide me on this.
Appreciate your help and Thanks in advance.
Regards,
Bhushan P