https://community.qlik.com/t5/App-Development/Replace-null-values-with-0-dynamically/m-p/2162505#M94359 <P>I have a table that each once in a while we add a new column, i cannot keep adding columns one by one putting that if( isnull(), 0, column) as column</P> <P>i want to turn it to do it dynamically for all the columns of the table whenever there is null value replace it with 0</P> <P>How?</P> Wed, 17 Jan 2024 16:01:37 GMT h2bi 2024-01-17T16:01:37Z https://community.qlik.com/t5/App-Development/Replace-null-values-with-0-dynamically/m-p/2162505#M94359 <P>I have a table that each once in a while we add a new column, i cannot keep adding columns one by one putting that if( isnull(), 0, column) as column</P> <P>i want to turn it to do it dynamically for all the columns of the table whenever there is null value replace it with 0</P> <P>How?</P> Wed, 17 Jan 2024 16:01:37 GMT https://community.qlik.com/t5/App-Development/Replace-null-values-with-0-dynamically/m-p/2162505#M94359 h2bi 2024-01-17T16:01:37Z https://community.qlik.com/t5/App-Development/Replace-null-values-with-0-dynamically/m-p/2162523#M94363 <P>Hello,</P> <P>NullAsValue *;<BR />SET NullValue='0';</P> <P><A href="https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/NullAsValue.htm" target="_blank">https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/NullAsValue.htm</A></P> <P>&nbsp;</P> <P>regards,</P> Wed, 17 Jan 2024 16:35:20 GMT https://community.qlik.com/t5/App-Development/Replace-null-values-with-0-dynamically/m-p/2162523#M94363 kfoudhaily 2024-01-17T16:35:20Z