Discussion board where members can get started with QlikView.
Hi, does anybody know how to retrieve an "a" value in formula y=bx+a from LINEST functions?
Thank you for the clarification, Stefan! You've helped me a lot!
You can see it also when you change the x-values:
LOAD * INLINE [
--> automatic equation doesn't change! Only y-values have an impact on equation values
I assume Qlik is just using the dimensional values autonumber'ed 0...n and use this as x-axis values.
Advantage: you can calculate an regression line also on textual x-values
Disadvantage: it's not a correct regression calculation, IMO
edit: Forgot to say: the automatic equation is correct if you change axis to continouus axis on axis tab.
Thanks again, Stefan. Now i understand better this issue Great edit at least the equation is right now!
Hi, i understand that linest function works well for univariate linear regression. what about mutlivariate regression?