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: 
Evan0211
Creator II
Creator II

Why is this expressing to null?

I can't seem to figure out why this is expressing to null (-) instead of 0:

=IF(LEN(TRIM(fieldname)) = 0, 0 , Len(fieldname))

null check error.jpg

Labels (1)
1 Reply
Evan0211
Creator II
Creator II
Author

This also expresses to (-) instead of string null.

=if(isnull(fieldname), 'null', fieldname)