Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
in qlikview we have "is null" function like that
we have "is not null" function?
if "is not null" not exist in qlikview function how to do for the "is not null" function in another way?
I think for this we can use
Not IsNull function
Please share your expected output with sample file
=Not IsNull()
Hi,
IsNull()
Not IsNull()
or Len(Trim(Field)) = 0 // or > 0
Regards,
Antonio
i think there is no "not is null" we have use to
belo condition
if (is null(fieldname)<>-1)
let me know ur thoughts
Wrong Syntax
IsNull(Field) is already boolean condition
You can try like:
1) if (isnull(fieldname)=0, 'Not Null', 'Null')
2) if (not isnull(fieldname), 'Not Null', 'Null')
3) if (isnull(fieldname), 'Null', 'Not Null')