Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chesterluck
Contributor II

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
chesterluck
Contributor II

Re: Problems calculating Linest_b (way to high)

Got it:

b=Linest_M*min(x_Axis)+Linest_B

1 Reply
chesterluck
Contributor II

Re: Problems calculating Linest_b (way to high)

Got it:

b=Linest_M*min(x_Axis)+Linest_B

Community Browser