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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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)