Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Verify Is null value in set analisys

Hello,

How can i test VALUE NULL in set analisys?

Thank you

4 Replies
Sokkorn
Honored Contributor

Verify Is null value in set analisys

Hi,

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

Regards,

Sokkorn Cheav

sridhar240784
Contributor III

Verify Is null value in set analisys

You may also try the below code.

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

-Sridhar

Not applicable

Verify Is null value in set analisys

Hi,

You could simply use

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

This might help you.

Good Luck

Regards,

Nitin Jain

erich_shiino
Honored Contributor

Verify Is null value in set analisys

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

Community Browser