topic Re: How do I add null values to my count in QlikView

How do I add null values to my count

Tue, 22 Jul 2014 14:20:38 GMT

I am using the formula below to find work orders that are late. I would like to add to my count the work orders that have a null completed date and the WO Required Date.AgeInDays >=1. Any ideas would be greatly appreciated. Thanks in advance for your help on this item.

count (if([WO Complete Date.CalendarDate] > [WO Required Date.CalendarDate],1))

Re: How do I add null values to my count

Anonymous — Tue, 22 Jul 2014 14:24:46 GMT

Try this

count (if([WO Complete Date.CalendarDate] =''))

count(if(isnull(([WO Complete Date.CalendarDate])

If this doesn't work let me know

Re: Re: How do I add null values to my count

Anonymous — Tue, 22 Jul 2014 14:34:16 GMT

Maybe something like this ?

count (

if([WO Complete Date.CalendarDate] > [WO Required Date.CalendarDate] ,

)

+ count( if ( [WO Required Date.AgeInDays] >=1 ,

if ( isnull([WO Complete Date.CalendarDate] ) ,

1 )

)

Re: How do I add null values to my count

Tue, 22 Jul 2014 14:36:28 GMT

Hello Jebamalai,

Thanks for the response. Unfortunately, neither of the formulas below worked.

Regards,

Shedrick

Re: How do I add null values to my count

martynlloyd — Tue, 22 Jul 2014 14:36:31 GMT

Check out The NullAsValue statement.

Re: How do I add null values to my count

Anonymous — Tue, 22 Jul 2014 15:01:58 GMT

What kind of 'not work' ?

Re: How do I add null values to my count

Tue, 22 Jul 2014 15:12:29 GMT

Bill,

It looks like it is working now. I just added one last ) on the end of the expression and now it is ok. I am going to do some more testing to ensure it is working properly. Thanks so much for your help.

Regards,

Shedrick