QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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_M _ Linest_B _ Linest_R2

y= Value

x= TimeAxis

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

Any suggestions?

//chesterluck

Tags (3)
1 Solution

Accepted Solutions
Contributor II

Re: Problems calculating Linest_b (way to high)

Got it:

b=Linest_M*min(x_Axis)+Linest_B