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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator II
Creator II

Display null or missing values

have an issue with displaying null or missing value. Tried is null function but still the column value is displayed as -.

Any help is appreciated.

2 Replies
Lisa_P
Employee
Employee

You can use the NullAsValue function to load another value into those values which are detected as null so they can be visible, see help link:
https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegula... 

jjustingkm
Creator II
Creator II
Author

Thanks Lisa for the reply. In this cases the filed doesn't return any null values i guess, but when associate with another table it ends up giving null values since it doesn't have any values corresponding the records in the associated table.