Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Field looks like it is blank but isnull function does not work

dear QV users,

I would like to use the isnull function for a field, but the field looks like it's blank, but isn't.

Are there other functions to solve this?

With kind regards,

Aissam

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

if( len(trim(FIELD))=0, ..

or

if( len(trim(purgechar(FIELD, chr(160)))) = 0,...

instead of

if( isnull(FIELD), ...

http://community.qlik.com/message/182388

View solution in original post

3 Replies
Anonymous
Not applicable
Author

If isnull() doesn't work, you can try trim(field)=''
This will test for blank fields.
-Phil

IAMDV
Master II
Master II

Aissam - You can also use IsText() and IsNum() boolean functions to evaluate the field value. Does it show the '-' in the field value?

Cheers,

DV

www.QlikShare.com

swuehl
MVP
MVP

Try

if( len(trim(FIELD))=0, ..

or

if( len(trim(purgechar(FIELD, chr(160)))) = 0,...

instead of

if( isnull(FIELD), ...

http://community.qlik.com/message/182388