null in qlikview

[Anonymous]

how does null works in qlikview?

what is the difference in isnull(field)  ??

and field='null'  ??

[jaumecf23]

To check if a field is null, you need to choose the first formula you said : isnull(field). Because the second one checks if the field has a string value and when it's null it has not a string value.

[YoussefBelloum]

Hi,

try also to read this:

The Importance of Nothing

Finding NULL

NULL – The Invisible Nothing