topic Re: NullCount() vs MissingCount() in QlikView

NullCount() vs MissingCount()

Wed, 15 Jan 2014 14:05:47 GMT

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

NullCount(items)

MIssingCount(items)

Thanks

Re: NullCount() vs MissingCount()

jvitantonio — Wed, 15 Jan 2014 14:19:17 GMT

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.

Re: NullCount() vs MissingCount()

danieloberbilli — Wed, 15 Jan 2014 14:22:11 GMT

Nulls means nothing.

Missing means non-numeric or an empty text string

Re: NullCount() vs MissingCount()

Wed, 29 Apr 2015 20:41:00 GMT

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

Re: NullCount() vs MissingCount()

ToniKautto — Thu, 30 Apr 2015 03:58:16 GMT

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.