Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jblomqvist
Contributor II

What is the best way to handle NULL values when it comes to Date and Numeric fields?

Hello,

I have a series of tables where we have lots of null values in various fields.

In Dimension type fields it is easy to set them to "Unknown" etc.

What is the best way to handle NULL values when it comes to Date and Numeric fields? If I also set both of these types of fields to replace Null with "Not known" - is that problematic? Is it poor practise?

What is a good alternative for null values for Date and Numeric type fields?

1 Reply
YoussefBelloum
Esteemed Contributor

Re: What is the best way to handle NULL values when it comes to Date and Numeric fields?

Hi,

a lot of experts here use this:

len(trim(FIELD))=0

this will handle NULL and EMPTY cells and also replace the Isnull() function

give it a try

=if(len(trim(FIELD))=0;'NULL', FIELD) as FIELD

Community Browser