Replace Null Values for 0

[brunopaulo]

Hi, I'm loading several excel files with diferente fields. I want to create a condition that replace null values for 0.
I know how to do for a specifc field but in this case the name of field can be variable (more then 100 fields) so i want create a condtion for table.

Check Table if null replace to 0.

Anyone has idea how to do it? Thanks in advance

Regards

[Mark_Little]

Hi Bruno,

Take a look at null as value.

NullAsValue ‒ Qlik Sense

[zhadrakas]

Try this code above your load script.

NullAsValue *; SET NullValue = ‘0’;

regards

tim

[brunopaulo]

Didnt work. But this is the way

[zhadrakas · Accepted solution]

you can try to add this line. Maybe QlikView dont recognize that the empty cells are real NULL Values.

SET NullInterpret = ‘’;

regards

tim

[brunopaulo]

Thank you, solved it!!!!