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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to handle a blank field value in a INLINE table

Hey,

I have problems regarding to blank fields. I m going to build a table with with an easy expression. When the field value is blank give back a Z when there is a number give back a U...

I hope anyone can help me

Thank you...

1 Reply
sunny_talwar

Try using this expression to check for blanks (including white spaces)

= If(Len(Trim(Zahl)) = 0, 'Z', 'U')


Capture.PNG