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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to handle null values in expression

Hi,
I want to handle null values in my input column...
Input data for postal code is 9 digits, for this i need to display the postal code as xxxxx-xxxx like this in target table, when I try to convert like this getting some errors due to null values are there in input data, so please help me on this.

Labels (2)
1 Reply
Anonymous
Not applicable
Author

(!Relational.isNull(row2.postalCode) && row2.postalCode.lenght >5)?true:false


by using this method you can avoid this error.