topic Verify Is null value in set analisys in QlikView

Verify Is null value in set analisys

Mon, 19 Dec 2011 00:04:37 GMT

Hello,

How can i test VALUE NULL in set analisys?

Thank you

Sokkorn — Mon, 19 Dec 2011 02:58:45 GMT

Hi,

Try this =Sum({$<Field -= "=Null()">} Amt)

Regards,

Sokkorn Cheav

sridhar240784 — Mon, 19 Dec 2011 05:11:22 GMT

You may also try the below code.

=Sum({<Field = {"=Len(Field) = 0"} >} Sales)

-Sridhar

Mon, 19 Dec 2011 09:06:06 GMT

Hi,

You could simply use

sum({<Field_Name1 -={}>} Field_Name2)

This might help you.

Good Luck

Regards,

Nitin Jain

erichshiino — Wed, 21 Dec 2011 20:09:51 GMT

You can include a flag in your script to test the field:

Load FIELD1,

IF( ISNULL(FIELD1), 1, 0) as FlagNullField1,

FIELD2

...

Then, you can test this field on set analysis:

sum({<FlagNullField1 ={1}>} FIELD2)

---> This will sum FIELD2 where FIELD1 is null

Regards,

Erich