topic Re: Count for Null in QlikView

Count for Null

k_burata — Wed, 25 Nov 2020 16:16:04 GMT

Hi I have been trying to count rows which looks at when a column is not null but seem to be getting no where.

Here's my data:

So I'm trying to count rows which has no Payment Ticked of Amount. It works well when I count those that have value more than 0.

"=Count({<[Payment Ticked of Amount] = {"*"}>} [Payment Ticked of Amount])" gives me 2

But "=Count({<[Payment Ticked of Amount] -= {"*"}>} [Payment Ticked of Amount])" gives me 0. Should be 3.

TIA.

fabdulazeez — Thu, 08 Mar 2018 04:23:16 GMT

you are trying to count null values

Try

"=Count({<[Payment Ticked of Amount] -= {"*"}>} [Payment Series ID])"

tamilarasu — Thu, 08 Mar 2018 04:30:25 GMT

Hi Kim,

=Count({<[Payment Series ID] = {"=Len(Trim([Payment Ticket of Amount]))=0"}>} [Payment Series ID])

jonathandienst — Thu, 08 Mar 2018 04:40:14 GMT

Count only counts non-null values. Therefore there is a NullCount() function:

=NullCount([Payment Ticked of Amount])

Digvijay_Singh — Thu, 08 Mar 2018 04:41:00 GMT

May be try this -

NullCount([Payment Ticked of Amount] )

k_burata — Thu, 08 Mar 2018 05:14:57 GMT

This worked for me.

Cheers!