Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Try the linest_m function. See the help file for details on how to use that function.
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)
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.
Here we go, it is a very simple example. I am trying to get 940 value and the X axis is the months