X coefficient for a Linear equation

[#1]

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,

[Gysbert_Wassenaar]

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

[#3]

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)

[Gysbert_Wassenaar]

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.

[#5]

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