topic Sum If Count in Misure Expression in App Development https://community.qlik.com/t5/App-Development/Sum-If-Count-in-Misure-Expression/m-p/33539#M2233 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hello to All!</P><P style="font-size: 13.3333px;">I want a measure that counts only <STRONG>Incident_Number</STRONG> where the number of <STRONG>ACT_Call_Incident_Relationship.Call_Request_ID is = 1</STRONG>.</P><P style="font-size: 13.3333px;">I wrote in this way</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Sum(If(Count([ACT_Call_Incident_Relationship.Call_Request_ID])=1 and Count(DISTINCT Incident_Number)=1,1,0))</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">But I get an error in the expression.</P><P style="font-size: 13.3333px;">&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 226px;"><TBODY><TR><TD class="xl112" height="20" width="117"><STRONG>Incident_Number</STRONG></TD><TD class="xl112" style="border-left: none;" width="109"><STRONG>Call_Request_ID</STRONG></TD></TR><TR><TD class="xl111" height="20" style="border-top: none;">Inc001</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re01</TD></TR><TR><TD class="xl111" height="20" style="border-top: none;">Inc001</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re02</TD></TR><TR><TD class="xl111" height="20" style="border-top: none;">Inc001</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re03</TD></TR><TR><TD class="xl111" height="20" style="border-top: none;">Inc002</TD><TD class="xl113" style="border-top: none; border-left: none;"><STRONG style="color: #ff0000;">Call_re04</STRONG></TD></TR><TR><TD class="xl111" height="19" style="border-top: none;">Inc003</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re05</TD></TR><TR><TD class="xl111" height="19" style="border-top: none;">Inc003</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re06</TD></TR><TR><TD class="xl111" height="19" style="border-top: none;">Inc004</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re07</TD></TR><TR><TD class="xl111" height="19" style="border-top: none;">Inc004</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re08</TD></TR><TR><TD class="xl111" height="20" style="border-top: none;">Inc005</TD><TD class="xl113" style="border-top: none; border-left: none;"><P><STRONG style="color: #ff0000;">Call_re09</STRONG></P></TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;">The result should be <STRONG>2</STRONG></P><P style="font-size: 13.3333px;">Can someone help me with this matter?</P></BODY></HTML> Fri, 13 Apr 2018 13:35:54 GMT Anonymous 2018-04-13T13:35:54Z Sum If Count in Misure Expression https://community.qlik.com/t5/App-Development/Sum-If-Count-in-Misure-Expression/m-p/33539#M2233 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hello to All!</P><P style="font-size: 13.3333px;">I want a measure that counts only <STRONG>Incident_Number</STRONG> where the number of <STRONG>ACT_Call_Incident_Relationship.Call_Request_ID is = 1</STRONG>.</P><P style="font-size: 13.3333px;">I wrote in this way</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Sum(If(Count([ACT_Call_Incident_Relationship.Call_Request_ID])=1 and Count(DISTINCT Incident_Number)=1,1,0))</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">But I get an error in the expression.</P><P style="font-size: 13.3333px;">&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 226px;"><TBODY><TR><TD class="xl112" height="20" width="117"><STRONG>Incident_Number</STRONG></TD><TD class="xl112" style="border-left: none;" width="109"><STRONG>Call_Request_ID</STRONG></TD></TR><TR><TD class="xl111" height="20" style="border-top: none;">Inc001</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re01</TD></TR><TR><TD class="xl111" height="20" style="border-top: none;">Inc001</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re02</TD></TR><TR><TD class="xl111" height="20" style="border-top: none;">Inc001</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re03</TD></TR><TR><TD class="xl111" height="20" style="border-top: none;">Inc002</TD><TD class="xl113" style="border-top: none; border-left: none;"><STRONG style="color: #ff0000;">Call_re04</STRONG></TD></TR><TR><TD class="xl111" height="19" style="border-top: none;">Inc003</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re05</TD></TR><TR><TD class="xl111" height="19" style="border-top: none;">Inc003</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re06</TD></TR><TR><TD class="xl111" height="19" style="border-top: none;">Inc004</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re07</TD></TR><TR><TD class="xl111" height="19" style="border-top: none;">Inc004</TD><TD class="xl111" style="border-top: none; border-left: none;">Call_re08</TD></TR><TR><TD class="xl111" height="20" style="border-top: none;">Inc005</TD><TD class="xl113" style="border-top: none; border-left: none;"><P><STRONG style="color: #ff0000;">Call_re09</STRONG></P></TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;">The result should be <STRONG>2</STRONG></P><P style="font-size: 13.3333px;">Can someone help me with this matter?</P></BODY></HTML> Fri, 13 Apr 2018 13:35:54 GMT https://community.qlik.com/t5/App-Development/Sum-If-Count-in-Misure-Expression/m-p/33539#M2233 Anonymous 2018-04-13T13:35:54Z Re: Sum If Count in Misure Expression https://community.qlik.com/t5/App-Development/Sum-If-Count-in-Misure-Expression/m-p/33540#M2234 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count(DISTINCT {&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Incident_Number = {"=Count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">[ACT_Call_Incident_Relationship.Call_Request_ID]) = 1</SPAN>"}</SPAN>&gt;} </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><STRONG>Incident_Number)</STRONG></SPAN></P></BODY></HTML> Fri, 13 Apr 2018 17:00:25 GMT https://community.qlik.com/t5/App-Development/Sum-If-Count-in-Misure-Expression/m-p/33540#M2234 sunny_talwar 2018-04-13T17:00:25Z Re: Sum If Count in Misure Expression https://community.qlik.com/t5/App-Development/Sum-If-Count-in-Misure-Expression/m-p/33541#M2235 <HTML><HEAD></HEAD><BODY><P>Thanks a lot!!!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 16 Apr 2018 07:17:52 GMT https://community.qlik.com/t5/App-Development/Sum-If-Count-in-Misure-Expression/m-p/33541#M2235 Anonymous 2018-04-16T07:17:52Z