topic Re: X coefficient for a Linear equation in QlikView

X coefficient for a Linear equation

Sun, 10 Feb 2013 11:11:05 GMT

Gentlemen,

Currently Qlikview support trend lines in charts and it uses different methods to calculate them like linear, exponential, average etc. There is a tick box in the chart properties to show the equation of the trend line. Is there an equivalent function i could use to get the coefficient of X value in a linear trend line.

Regards,

Re: X coefficient for a Linear equation

Gysbert_Wassenaar — Sun, 10 Feb 2013 12:21:59 GMT

Try the linest_m function. See the help file for details on how to use that function.

Re: X coefficient for a Linear equation

Sun, 10 Feb 2013 12:24:52 GMT

I tried to use that but I was facing some deficulties with the parameters cosidering that i am using only one felid values for the trend expression. the help state that there should be 2 variables (I guss)

Re: X coefficient for a Linear equation

Gysbert_Wassenaar — Sun, 10 Feb 2013 12:33:08 GMT

You have something with numeric values that's displayed on your x-axis. That could be an expression or it is a dimension. That's what you input as x-expression parameter in linest_m. And same for whatever produces the values for your y-axis, that's your y-expression parameter.

Re: X coefficient for a Linear equation

Sun, 10 Feb 2013 12:41:56 GMT

Here we go, it is a very simple example. I am trying to get 940 value and the X axis is the months