topic Sum based on two conditions in App Development https://community.qlik.com/t5/App-Development/Sum-based-on-two-conditions/m-p/1662999#M49833 <P>Hello - I am trying to create a Sum expression based on two conditions - If Field A is distinct, and Field B is the same, sum the quantity. The example data set:&nbsp;</P><TABLE><TBODY><TR><TD>Matching</TD><TD>Matching1</TD><TD>Quantity</TD></TR><TR><TD>12345</TD><TD>68038986</TD><TD>-310.000</TD></TR><TR><TD>12345</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>12345</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>56789</TD><TD>68038986</TD><TD>-310.000</TD></TR><TR><TD>56789</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>56789</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>34567</TD><TD>68038986</TD><TD>-310.000</TD></TR><TR><TD>34567</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>34567</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>98765</TD><TD>68038986</TD><TD>-310.000</TD></TR><TR><TD>98765</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>98765</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>10293</TD><TD>68038986</TD><TD>310.000</TD></TR><TR><TD>10293</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>10293</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>28374</TD><TD>68038986</TD><TD>310.000</TD></TR><TR><TD>28374</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>28374</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>74563</TD><TD>68038986</TD><TD>310.000</TD></TR><TR><TD>74563</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>74563</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>57893</TD><TD>68038986</TD><TD>310.000</TD></TR><TR><TD>57893</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>57893</TD><TD>68038986</TD><TD>-</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In this case,&nbsp; take distinct Matching value and Matching1 = Matching1, then sum the quantity. Using these conditions you would get a net zero quantity with this example.&nbsp;</P><P>I have the first part figured out, but not sure how to add the second condition where Matching1 is the same:&nbsp;</P><P>sum(aggr(sum(DISTINCT [Quantity]), [Matching]))</P><P>Any help is appreciated.&nbsp;</P> Mon, 06 Jan 2020 15:53:07 GMT jfelker88 2020-01-06T15:53:07Z Sum based on two conditions https://community.qlik.com/t5/App-Development/Sum-based-on-two-conditions/m-p/1662999#M49833 <P>Hello - I am trying to create a Sum expression based on two conditions - If Field A is distinct, and Field B is the same, sum the quantity. The example data set:&nbsp;</P><TABLE><TBODY><TR><TD>Matching</TD><TD>Matching1</TD><TD>Quantity</TD></TR><TR><TD>12345</TD><TD>68038986</TD><TD>-310.000</TD></TR><TR><TD>12345</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>12345</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>56789</TD><TD>68038986</TD><TD>-310.000</TD></TR><TR><TD>56789</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>56789</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>34567</TD><TD>68038986</TD><TD>-310.000</TD></TR><TR><TD>34567</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>34567</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>98765</TD><TD>68038986</TD><TD>-310.000</TD></TR><TR><TD>98765</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>98765</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>10293</TD><TD>68038986</TD><TD>310.000</TD></TR><TR><TD>10293</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>10293</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>28374</TD><TD>68038986</TD><TD>310.000</TD></TR><TR><TD>28374</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>28374</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>74563</TD><TD>68038986</TD><TD>310.000</TD></TR><TR><TD>74563</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>74563</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>57893</TD><TD>68038986</TD><TD>310.000</TD></TR><TR><TD>57893</TD><TD>68038986</TD><TD>-</TD></TR><TR><TD>57893</TD><TD>68038986</TD><TD>-</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In this case,&nbsp; take distinct Matching value and Matching1 = Matching1, then sum the quantity. Using these conditions you would get a net zero quantity with this example.&nbsp;</P><P>I have the first part figured out, but not sure how to add the second condition where Matching1 is the same:&nbsp;</P><P>sum(aggr(sum(DISTINCT [Quantity]), [Matching]))</P><P>Any help is appreciated.&nbsp;</P> Mon, 06 Jan 2020 15:53:07 GMT https://community.qlik.com/t5/App-Development/Sum-based-on-two-conditions/m-p/1662999#M49833 jfelker88 2020-01-06T15:53:07Z Re: Sum based on two conditions https://community.qlik.com/t5/App-Development/Sum-based-on-two-conditions/m-p/1666515#M50193 <P>Please try:</P><P><SPAN>sum(aggr(sum(DISTINCT [Quantity]), [Matching],[Matching1]))</SPAN></P> Thu, 16 Jan 2020 22:32:50 GMT https://community.qlik.com/t5/App-Development/Sum-based-on-two-conditions/m-p/1666515#M50193 jochem_zw 2020-01-16T22:32:50Z