topic Re: Counting NULL values in QlikView

Counting NULL values

Wed, 06 Feb 2013 14:47:38 GMT

Hi all,

I am looking to count LOCATION = London where L_ID is Null

LOCATION L_ID

London -

North London 1214

London 2485

London -

London 4789

NW London -

The expression I had written doesnt seem to work:

Count(IF(LEN(L_ID < 0) , LOCATION = 'LONDON'))

Thanks.

Koushik.

alexandros17 — Wed, 06 Feb 2013 14:49:21 GMT

try this

Count(IF(isnull(L_ID) , LOCATION = 'LONDON'))

Wed, 06 Feb 2013 14:56:32 GMT

Nope, doesnt work.

In the above table if you see the null values are 3 therfore the Loctaion = 'LONDON' cannot exceed 3 but I get more than 3 values.

Gysbert_Wassenaar — Wed, 06 Feb 2013 15:06:36 GMT

try:

count({<Location={'London'},L_ID-={'*'}>} Location)

Wed, 06 Feb 2013 15:38:57 GMT

Thanks Gysbert Wassennar