topic Re: Help on null due data set analysis in QlikView

Help on null due data set analysis

Tue, 12 Jun 2012 12:41:23 GMT

Hello,

I'm trying to see the average time that each customer has for its non-payed bills.

I have two field is "payment date" and "due date" and I would like to average the bills that are not payed.

Payment date = DATARECEBIMENTO

Due date = DATAVENCIMENTO

So I did this:

avg({$-<DATARECEBIMENTO={"null"}>} (TODAY() - DATAVENCIMENTO))

but the result is the same as

avg(TODAY() - DATAVENCIMENTO)

So i assume that in both cases it is calculating for all the bills, the whole $.

Any help?

Thanks!

Tue, 12 Jun 2012 23:34:40 GMT

Hi,

1) "null" is not a real null, it is a string whose value is null. So, pls. be careful about it.

2) Can you provide a sample qlikview application or some data?

Regards,

Sokkorn — Wed, 13 Jun 2012 00:58:01 GMT

Hi lucascli,

Maybe I got you wrong. But let try this set analysis

=AVG({$<DATARECEBIMENTO -={"null()"}>} (TODAY() - DATAVENCIMENTO))

Do let me know after you tested.

Regards,

Sokkorn