Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problems calculating Linest_b (way to high)

Hello

I'm calculating a regression function for a chart. Im not using the integrated Forecast-Line as it is not calculated correctly due to a bug.

Linest_M = -0.039 and it seems correct. But Linest_B where x and y are chosen exactly the same way as in Linest_M is way to high = 1640 (and should be 7)

Am I doing sth terribly wrong?

Linest_B_1.png

Linest_B_2.png

= Linest_M _ Linest_B _ Linest_R2

y= Value

x= TimeAxis

Apropos, in the chart b seems to be correct...

Any suggestions?

Thx in advance!

//chesterluck

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Got it:

b=Linest_M*min(x_Axis)+Linest_B

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Got it:

b=Linest_M*min(x_Axis)+Linest_B