Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Linest functions

Hi, does anybody know how to retrieve an "a" value in formula y=bx+a from LINEST functions?

13 Replies
Highlighted
Specialist
Specialist

Thank you for the clarification, Stefan! You've helped me a lot!

Highlighted
MVP
MVP

You can see it also when you change the x-values:

LOAD * INLINE [

Name, ValueID

1, 2

6, 6

7, 8

];

--> 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.

Highlighted
Specialist
Specialist

Thanks again, Stefan. Now i understand better this issue
Great edit at least the equation is right now!

Highlighted
Partner
Partner

Hi, i understand that linest function works well for univariate linear regression. what about mutlivariate regression?