Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: How to handle a blank field value in a INLINE table

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

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


Capture.PNG

Community Browser