topic Re: Using an expression for Countif conditions in QlikView https://community.qlik.com/t5/QlikView/Using-an-expression-for-Countif-conditions/m-p/29182#M780707 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(If(RangeSum(A, B, C) = 1, D, 0)</STRONG></P></BODY></HTML> Thu, 29 Mar 2018 14:41:21 GMT sunny_talwar 2018-03-29T14:41:21Z Using an expression for Countif conditions https://community.qlik.com/t5/QlikView/Using-an-expression-for-Countif-conditions/m-p/29181#M780706 <HTML><HEAD></HEAD><BODY><P>Hey everybody,</P><P></P><P>I am trying to run a CountIf wherein whenever the SUM of A,B and C equals 1, D is counted.</P><P></P><P>For example, in the below picture, I should get a count of 3.</P><P><IMG __jive_id="197854" alt="Qlikview countif.PNG" class="jive-image image-1" src="/legacyfs/online/197854_Qlikview countif.PNG" /></P><P></P><P>I tried a few expressions including the following one&nbsp; =Count({&lt;A+B+C=1&gt;} D), but don't seem to get a result.</P><P></P><P>Would appreciate if I could get your thoughts on this.</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-for-Countif-conditions/m-p/29181#M780706 Anonymous 2020-11-25T16:16:04Z Re: Using an expression for Countif conditions https://community.qlik.com/t5/QlikView/Using-an-expression-for-Countif-conditions/m-p/29182#M780707 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(If(RangeSum(A, B, C) = 1, D, 0)</STRONG></P></BODY></HTML> Thu, 29 Mar 2018 14:41:21 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-for-Countif-conditions/m-p/29182#M780707 sunny_talwar 2018-03-29T14:41:21Z Re: Using an expression for Countif conditions https://community.qlik.com/t5/QlikView/Using-an-expression-for-Countif-conditions/m-p/29183#M780708 <HTML><HEAD></HEAD><BODY><P>Try Rangesum function, already suggested by Sunny, The Savior&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 30 Mar 2018 06:52:43 GMT https://community.qlik.com/t5/QlikView/Using-an-expression-for-Countif-conditions/m-p/29183#M780708 shiveshsingh 2018-03-30T06:52:43Z