Functions In Qlikview For Slope And Intercept

Fri, 13 Nov 2009 16:54:06 GMT

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

Re: Functions In Qlikview For Slope And Intercept

Anonymous — Tue, 21 Apr 2015 17:41:09 GMT

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.

topic Re: Functions In Qlikview For Slope And Intercept in QlikView

Functions In Qlikview For Slope And Intercept

Re: Functions In Qlikview For Slope And Intercept