Comparing field value to NULL in set analysis

[#1]

I need to have a chart where expression should produce a count of field A when field B is  NULL and second count when field B  is not NULL.

Something like this but with correct syntax.

=count({$<=NULL>}) - this does not work

Is there any other way to implement such logic?

Thank you

[danielrozental]

No, there is no way to select null values.

You could try something like this count(if(isnull(B),A))

[#3]

What if I replae NULLs with soething else during the load - lets say with string "xyz". can I use

=count({$<="xyz">}) ?

[danielrozental]

Yes, but the correct expression would be

=count({$<={'xyz'}>})

[#5]

Try...

= Count ({$ < = {$(=null())}>} )  //  Null

= Count ({$ < -= {$(=null())}>} )  //  Not null

[#6]

ehilsinger - it does not work for me, did it work for you?

[erichshiino]

Hi,

You can write something like this:

count({1-<={*}>})

Explanation:

count({<={*}>}) -> this will count A where B has any value (can be a blank but not a null)

count({1-<={*}>}) -> the '1-' tells that you want to see everything (1) excluding cases where B has value

Hope this helps,

Erich

[#8]

counts A when B is null

=count({$<={"=isnull(B)"}>})

counts A when B is not null

=count({$<={"*"}>})

[raajeshn]

Hi Erich,

I also had a similar problem and your solution worked for me. Thanks a lot.

Regards,

Raajesh N

[qliksus]

Hi u can try something like

count({$<={"=NULLCOUNT()>0"}>}) +

count({$<={"=NULLCOUNT()=0"}>})