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

Count expression with multiple checks

Hi

I need some help with an expression im am using for a text object. I have two things in need to check for and i dont really know how to go about this. Basically I need to count items if they have a type of REPAIR and if there is an ARRIVE_DATE. I currently have this:

=COUNT(INCIDENT_TYPE_ID = 'REPAIR')

This I would have assumed would bring me the number or incident with a type of REPAIR however this doest, it somehow brings back the total number of incidents regardless of there type. And what would the syntax be to check for an ARRIVE_DATE in this count.

Thanks in advance

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

COUNT(if(INCIDENT_TYPE_ID = 'REPAIR' and ARRIVE_DATE='dd/mm/yyyy',1,0))

hope it heklps

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

COUNT(if(INCIDENT_TYPE_ID = 'REPAIR' and ARRIVE_DATE='dd/mm/yyyy',1,0))

hope it heklps

Not applicable
Author

That works good for both, but how do i get it to work for just INCIDENT_TYPE_ID?