is not null

[manoranjan_d]

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]

I think for this we can use

Not IsNull function

Please share your expected output with sample file

[tresesco]

=Not IsNull()

[antoniotiman]

Hi,

IsNull()

Not IsNull()

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

Regards,

Antonio

[manoranjan_d]

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]

Wrong Syntax

IsNull(Field) is already boolean condition

[tresesco]

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