Set Analysis Problem

[eduardo_dimperio]

Hi,

i have a set analysis that not work. Whats wrong please?

count({<DIA0=-{}>} distinct OID_METER) Not recognize Null

IF (ISNULL(DIA0),'EMPTY') Recognize Null

[sunny_talwar]

In my very first response I mentioned this

What this means is that if a row has DIA0 as null, set analysis won't be able to put any filtration on that specific row based on DIA0... example

OID_METER          DIA0

1                              4

2                              Null()

3                              2

4                              4

5                              Null()

When you will use any set analysis on DIA0, consider it to start looking at 1, 3, & 4 rows only because the other two DIA0 are null....

But by using a set analysis on OID_METER, you can check if the Len(Trim(DIA0)) = 0 or not... if it is then count DIA0, else not..... But this can only work when there is a one to one relation between the ID field and DIA0... what this means is... if for example you have this

OID_METER          DIA0

1                              4

2                              Null()

3                              2

4                              4

5                              Null()

5                              4

It might not work the way you would want.... If you would want it to still count OID_METER 5, then it may not because there is another OID_METER 5 where DIA0 is not null....

I hope this helps.

Best,

Sunny

[eduardo_dimperio]

I understand, but look at my previous version of this app

count({<DIA0=-{}>} DISTINCT OID_METER)

and works !!! For that reason that i can understand why sometimes "Null values cannot be compare to anything in set analysis" are true and sometimes (like example below) are not.

[sunny_talwar]

This might have something to do with the new Quoteology

Quotes in Set Analysis