topic Re: Count expression with multiple checks in QlikView https://community.qlik.com/t5/QlikView/Count-expression-with-multiple-checks/m-p/430147#M487841 <HTML><HEAD></HEAD><BODY><P>That works good for both, but how do i get it to work for just INCIDENT_TYPE_ID?</P></BODY></HTML> Tue, 12 Feb 2013 16:58:46 GMT 2013-02-12T16:58:46Z Count expression with multiple checks https://community.qlik.com/t5/QlikView/Count-expression-with-multiple-checks/m-p/430145#M487839 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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:</P><P></P><P>=COUNT(INCIDENT_TYPE_ID = 'REPAIR') </P><P></P><P>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. </P><P></P><P>Thanks in advance </P></BODY></HTML> Tue, 12 Feb 2013 16:43:18 GMT https://community.qlik.com/t5/QlikView/Count-expression-with-multiple-checks/m-p/430145#M487839 2013-02-12T16:43:18Z Re: Count expression with multiple checks https://community.qlik.com/t5/QlikView/Count-expression-with-multiple-checks/m-p/430146#M487840 <HTML><HEAD></HEAD><BODY><P>COUNT(if(INCIDENT_TYPE_ID = 'REPAIR' and ARRIVE_DATE='dd/mm/yyyy',1,0))</P><P></P><P>hope it heklps</P></BODY></HTML> Tue, 12 Feb 2013 16:50:54 GMT https://community.qlik.com/t5/QlikView/Count-expression-with-multiple-checks/m-p/430146#M487840 alexandros17 2013-02-12T16:50:54Z Re: Count expression with multiple checks https://community.qlik.com/t5/QlikView/Count-expression-with-multiple-checks/m-p/430147#M487841 <HTML><HEAD></HEAD><BODY><P>That works good for both, but how do i get it to work for just INCIDENT_TYPE_ID?</P></BODY></HTML> Tue, 12 Feb 2013 16:58:46 GMT https://community.qlik.com/t5/QlikView/Count-expression-with-multiple-checks/m-p/430147#M487841 2013-02-12T16:58:46Z