topic Re: null in qlikview in QlikView

null in qlikview

Anonymous — Tue, 20 Feb 2018 07:53:27 GMT

how does null works in qlikview?

what is the difference in isnull(field) ??

and field='null' ??

Re: null in qlikview

jaumecf23 — Tue, 20 Feb 2018 08:33:12 GMT

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.

Re: null in qlikview

YoussefBelloum — Tue, 20 Feb 2018 08:43:39 GMT

Hi,

try also to read this:

The Importance of Nothing

Finding NULL

NULL – The Invisible Nothing