Count doesn't work

[JustinDallas]

Hello Everyone,

I must be going blind, but I have my Count set analysis not working and I've used it a million times before.  My text looks like so:

Count({<IsLessThanFiveDaysOut={1}>} [Trailer ID])

However, when I use this in a KPI callout, it counts every record.

The count value reads 1.03K, when in fact it should be zero because all the records have a Null value..

[vkish16161]

Good to know.

Please mark appropriate answers as helpful/ useful/ correct.

[swuehl]

Justin Dallas wrote:

Wait, if the column is Null, then it SHOULDN'T count it right?  Hell, even in some languages NULL != NULL, much less NULL != '1'

Have a look at

Set modifier problem with empty column

and for a general overview

NULL handling in QlikView