https://community.qlik.com/t5/App-Development/Sum-the-values-based-on-conditions/m-p/1808900#M65879 <P>Hi,</P><P>I need to sum 2 values based on some condition. I have entrydate, invoicedate, entryquantity, invoicequantity fields.</P><P>Requirement: If entrydate is selected it should sum entryquantiy and result is sum of entryquantity, if invoicedate is selected then it should Sum the invoicequantity and result is sum of invoicequantity.</P><P>This expression i need to build in one column in pivot table.&nbsp;</P> Sat, 16 Nov 2024 00:08:33 GMT kiru_18 2024-11-16T00:08:33Z https://community.qlik.com/t5/App-Development/Sum-the-values-based-on-conditions/m-p/1808900#M65879 <P>Hi,</P><P>I need to sum 2 values based on some condition. I have entrydate, invoicedate, entryquantity, invoicequantity fields.</P><P>Requirement: If entrydate is selected it should sum entryquantiy and result is sum of entryquantity, if invoicedate is selected then it should Sum the invoicequantity and result is sum of invoicequantity.</P><P>This expression i need to build in one column in pivot table.&nbsp;</P> Sat, 16 Nov 2024 00:08:33 GMT https://community.qlik.com/t5/App-Development/Sum-the-values-based-on-conditions/m-p/1808900#M65879 kiru_18 2024-11-16T00:08:33Z https://community.qlik.com/t5/App-Development/Sum-the-values-based-on-conditions/m-p/1808913#M65881 <P>Sum(If(GetSelectedCount(entrydate)&gt;0,entryquantiy, if(GetSelectedCount(invoicedate)&gt;0,invoicequantity)))</P> Wed, 19 May 2021 08:23:32 GMT https://community.qlik.com/t5/App-Development/Sum-the-values-based-on-conditions/m-p/1808913#M65881 Or 2021-05-19T08:23:32Z