topic Re: is not null in QlikView

is not null

manoranjan_d — Thu, 20 Jul 2017 07:41:05 GMT

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?

prma7799 — Thu, 20 Jul 2017 07:43:20 GMT

I think for this we can use

Not IsNull function

Please share your expected output with sample file

tresB — Thu, 20 Jul 2017 07:43:30 GMT

=Not IsNull()

antoniotiman — Thu, 20 Jul 2017 07:45:52 GMT

Hi,

IsNull()

Not IsNull()

or Len(Trim(Field)) = 0 // or > 0

Regards,

Antonio

manoranjan_d — Thu, 20 Jul 2017 07:50:48 GMT

i think there is no "not is null" we have use to

belo condition

if (is null(fieldname)<>-1)

let me know ur thoughts

antoniotiman — Thu, 20 Jul 2017 07:58:35 GMT

Wrong Syntax

IsNull(Field) is already boolean condition

tresB — Thu, 20 Jul 2017 08:10:02 GMT

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')