Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jblomqvist
Contributor II

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
Valued Contributor

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

SET NullValue = 'MISSING';

NullAsValue;