Null Count

[hkg_qlik]

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,

H

[v_iyyappan]

Hi

     Try like this,

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

Regards,

Iyyappan

[#3]

Using if

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

[hic]

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

HIC