Replace null values with 0 dynamically

[h2bi]

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

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

How?

[kfoudhaily]

Hello,

NullAsValue *;
SET NullValue='0';

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

regards,