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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

Is there a way to replace NULL values with MISSING for all the fields in a data model?

Hello,

Is there a way to replace all the NULL values with MISSING for all the fields in a Qlik Sense app data model?

Or what is the most efficient way to do it when you are dealing with many fields? I have almost 300 fields.

1 Reply
tomasz_tru
Specialist
Specialist

SET NullValue = 'MISSING';

NullAsValue;