Qlik Experts: What is the best replacement value for NULL values in numerical and date type fields?

[jblomqvist]

Hello Qlik experts,

What is the best replacement value for NULL values in numerical and date type fields?

I know for string you can replace a null value with something like 'MISSING'.

But handling Nulls in a numerical or date can be tricky.

What are your suggestions for handling null values for numerical and date type fields?

[dan_sullivan]

I typically leave them as null but create a new calculated column/flag for the null and flag it as 1/0 or Y/N so i can use that flag in calculations if necessary. 

[ahaahaaha]

Hi,

In my opinion, there is no need to replace the value of NULL, since in Qlik it is easily processed in fields of any type.

[Anonymous]

are you talking about real null() values or fields containing 'NULL' as a string?