https://community.qlik.com/t5/Data-Movement-Streaming/Null-as-value/m-p/2037630#M764 <P>Hi @Anonymous&nbsp;</P> <P>This expression changes all of a field's NULL values to "0.00%.".</P> <P>Coalesce(Field,'0.00%')</P> <P>or</P> <P>Perhaps with a NullAsValue statement as below.</P> <P>NullAsValue Field;</P> <P>Set NullValue = '0.00%';</P> <P>LOAD Field FROM SourceTable;</P> Tue, 14 Feb 2023 10:34:08 GMT BrunPierre 2023-02-14T10:34:08Z https://community.qlik.com/t5/Data-Movement-Streaming/Null-as-value/m-p/2037595#M763 <P>Hello Guys,</P> <P>How can I put 0% for all rows in my table.</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 19 Mar 2025 23:06:21 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Null-as-value/m-p/2037595#M763 Anonymous 2025-03-19T23:06:21Z https://community.qlik.com/t5/Data-Movement-Streaming/Null-as-value/m-p/2037630#M764 <P>Hi @Anonymous&nbsp;</P> <P>This expression changes all of a field's NULL values to "0.00%.".</P> <P>Coalesce(Field,'0.00%')</P> <P>or</P> <P>Perhaps with a NullAsValue statement as below.</P> <P>NullAsValue Field;</P> <P>Set NullValue = '0.00%';</P> <P>LOAD Field FROM SourceTable;</P> Tue, 14 Feb 2023 10:34:08 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Null-as-value/m-p/2037630#M764 BrunPierre 2023-02-14T10:34:08Z