Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I add null values to my count

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))

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Maybe something like this ?

count (

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

       1)

)

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

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

                                1 )

  )

View solution in original post

6 Replies
Anonymous
Not applicable
Author

Try this

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

or

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

If this doesn't work let me know

Anonymous
Not applicable
Author

Maybe something like this ?

count (

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

       1)

)

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

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

                                1 )

  )

Not applicable
Author

Hello Jebamalai,

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

Regards,

Shedrick

martynlloyd
Partner - Creator III
Partner - Creator III

Check out The NullAsValue statement.

Anonymous
Not applicable
Author

What kind of 'not work' ?

Not applicable
Author

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