Prediction using Qlikview

[#1]

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