topic Count where field is not null in QlikView

Count where field is not null

Fri, 09 Jul 2010 12:35:08 GMT

Dear all,

i want to do a numeric count of data that field DATA is null, but i don't know how to do that

numericcount({$<[DATA]=NULL}>} [DELIVERIES])

Can someone explain me how to do that.

Best regards

Miguel_Angel_Baeyens — Fri, 09 Jul 2010 12:42:40 GMT

Hello Jordi,

You may use

numericcount({$<[DATA]={""}>} [DELIVERIES])

numericcount({$<[DATA]={"=len([DATA]) = 0"}>} [DELIVERIES])

Hope that helps

sparur — Fri, 09 Jul 2010 12:43:18 GMT

Hello, Jordi

Try that:

=count(IF(Len(DATA)>0, [DELIVERIES]))

Fri, 09 Jul 2010 12:54:47 GMT

No ones work

sparur — Fri, 09 Jul 2010 12:59:43 GMT

Jordi, it's very strange.

because all approaches are works fine for me. see in example...