topic Re: Null count in QlikView

Null count

Sat, 19 Jan 2013 18:18:29 GMT

Hi,

I created a object for null count and its show me 1 count but column has no null value,

kindly guide me and i attached excel and application files.

Regards.

Zain.

rbecher — Sat, 19 Jan 2013 18:41:17 GMT

Hi Zain,

I think there is one representation of NULL for all missing KEYs from table OD. You will see the if you add KEY as a dimension.

- Ralf

Sat, 19 Jan 2013 19:57:55 GMT

Yes i know, any idea to avoid in null count and key is also important.

-Zain.

rbecher — Sat, 19 Jan 2013 22:11:39 GMT

This is an option, filter on another not key dimension:

nullcount({<COR.order_number={"*"}>} COR.return_detail_number)

- Ralf

Tue, 22 Jan 2013 11:53:26 GMT

Thanks its working for me.

Regards,

Zain.