topic Re: Null Count in QlikView

Null Count

hkg_qlik — Tue, 03 Jul 2012 19:30:59 GMT

Hi,

I have a Customer table.

I want to do Null Count for CUSTOMER_ID when ITEM_ID is NULL in the CUSTOMER Table.

Thanks,

v_iyyappan — Tue, 03 Jul 2012 20:39:29 GMT

Try like this,

=Count({<ITEM_ID ={' '}>} CUSTOMER_ID)

Regards,

Iyyappan

Tue, 03 Jul 2012 21:04:58 GMT

Using if

count( IF( IsNull(ITEM_ID ), CUSTOMER_ID) )

hic — Wed, 04 Jul 2012 18:38:26 GMT

There is a function NullCount() . The solution that adrianoalmeida suggests will work also. See more on http://community.qlik.com/docs/DOC-3155.

HIC