topic Is there a way to replace NULL values with MISSING for all the fields in a data model? in App Development https://community.qlik.com/t5/App-Development/Is-there-a-way-to-replace-NULL-values-with-MISSING-for-all-the/m-p/1340102#M29502 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is there a way to replace all the NULL values with MISSING for all the fields in a Qlik Sense app data model?</P><P></P><P>Or what is the most efficient way to do it when you are dealing with many fields? I have almost 300 fields.</P></BODY></HTML> Wed, 02 Aug 2017 18:28:25 GMT jblomqvist 2017-08-02T18:28:25Z Is there a way to replace NULL values with MISSING for all the fields in a data model? https://community.qlik.com/t5/App-Development/Is-there-a-way-to-replace-NULL-values-with-MISSING-for-all-the/m-p/1340102#M29502 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is there a way to replace all the NULL values with MISSING for all the fields in a Qlik Sense app data model?</P><P></P><P>Or what is the most efficient way to do it when you are dealing with many fields? I have almost 300 fields.</P></BODY></HTML> Wed, 02 Aug 2017 18:28:25 GMT https://community.qlik.com/t5/App-Development/Is-there-a-way-to-replace-NULL-values-with-MISSING-for-all-the/m-p/1340102#M29502 jblomqvist 2017-08-02T18:28:25Z Re: Is there a way to replace NULL values with MISSING for all the fields in a data model? https://community.qlik.com/t5/App-Development/Is-there-a-way-to-replace-NULL-values-with-MISSING-for-all-the/m-p/1340103#M29503 <HTML><HEAD></HEAD><BODY><P>SET NullValue = 'MISSING';</P><P>NullAsValue;</P></BODY></HTML> Wed, 02 Aug 2017 18:42:05 GMT https://community.qlik.com/t5/App-Development/Is-there-a-way-to-replace-NULL-values-with-MISSING-for-all-the/m-p/1340103#M29503 tomasz_tru 2017-08-02T18:42:05Z