NullCount() vs MissingCount()

[#1]

Can anyone please tell me or show me example of what're the differences between

NullCount(items)

MIssingCount(items)

Thanks

[jvitantonio]

Hi Jeannie,

NullCount() will only count those value that are null. Empty strings are not null values.

MissingCount will count all non-numeric values (even Null values).

Take a look at the attached app.

JV

[danieloberbilli]

Nulls means nothing.

Missing means non-numeric or an empty text string

[#4]

I added NumericCount(Item) and TextCount(Item) columns as well since your data was perfect to see how those worked too.

[ToniKautto]

The first thing you want to keep in mind is that QlikView (and Qlik Sense) uses dual values to store all data.

The dual value consists of two components, the value you see in the application and an underlying numerical value.

If you have an value like 1.5, there might be an underlying value that is equal to 1.4875.

If you have a thousand separator the visual value could look like 1,500, while the underlying number is 1500.

When there is no underlying numerical value, the value is considered as a text.

There can never be a underlying numerical value, without a text representing it.

When there is no text, there is no value. This empty space is referred to as a NULL value. NULL is typically presented as a dash in QlikView. This can be changed in sheet object properties, to enable distinguishing it from a text dash.

NullCount() will count all values that are defined as NULL.

MissingCount() will count all values without a underlying numerical representation, in other words all NULL values and all texts.