topic linest_m problem in QlikView

linest_m problem

Anonymous — Mon, 06 Oct 2014 10:32:51 GMT

I've an histogram chart.

The data I'm using are number of failure for month.

This is a simply example of data :

Jan: 1

Feb: null (no failure on Feb.)

Mar: 2

This is the function:

=linest_m(aggr(sum(QryFailure), Month), aggr(QryFailure, Month)

the function return 1 because not consider the null value of Feb.

but I've 0 failure on Feb and then I expect a coefficient that considering the values 1, 0, 2.

the correct result is 0

How can I do to have the correct value?

Frank_Hartmann — Sat, 06 Dec 2014 09:42:02 GMT

did you solve this problem? i´m facing the same problem right now.

Anonymous — Wed, 10 Dec 2014 13:14:33 GMT

I solve this problem with a new import select.

In SQL select I create (with a union) a record for each month with the QtyFailure value to Zero.

The new recordset is:

Jan: 1

Feb: null (no failure on Feb.)

Mar: 2

Jan: 0

Feb: 0

Mar: 0

now the linest_m function return the right value.