Functions In Qlikview For Slope And Intercept

[#1]

Dear All,

Can anybody please tell me the functions in qlikview to find slope and intercept as I can calculate in excel.

Please refer the attached file for your reference where slope and intercept is calculated. I want to calculate the same in qlikview.

Please suggest how i can achieve this as i am unable to find the exact functions to calculate slope and intercept.

Please provide a sample qlikview file if possible.

Thanks & Best Regards,
Kuldeep tak

[Anonymous]

Hi, this is quite old, but I was looking for the same to calculate the forecast, I got the solution in case it is useful for somebody. I found this

Intercept EquationThe Excel Slope Function uses the following equation to calculate the intercept of thelinear regression line through a set of given points:

where the slope, b is given by the equation:

and the values of  x  and  y  are the samples means (the averages) of the known_x's and the known_y's.

The attached example has the proper formulas in QV with some dummy data.