https://community.qlik.com/t5/QlikView/condition/m-p/1558392#M743127 <P>Perhaps this?</P><P><STRONG>Sum({&lt;MARKETING_DATE = {"=Sum(REFUND_AMOUNT)&lt;=Sum(RE_ACT_AMOUNT)"}&gt;} REFUND_AMOUNT)</STRONG></P> Tue, 19 Mar 2019 11:34:17 GMT Anil_Babu_Samineni 2019-03-19T11:34:17Z https://community.qlik.com/t5/QlikView/condition/m-p/1557627#M743124 <P>Dear Mr.SUNNY</P><P>PLEASE ADVISE ME A FORMULA TO OBTAIN THE REFUND_AMOUNT,&nbsp; IF THE MARKETING_DATE OF THE REFUND_AMOUNT HAS EXCEEDED THE&nbsp; MARKETING_DATE OF THE “RE_ACT_AMOUNT”&nbsp; IN&nbsp; A SAME POLICY.</P><P>&nbsp;</P><P>My excels file</P><TABLE><TBODY><TR><TD>POLICY_NO</TD><TD>MARKETING_DATE</TD><TD>TYPE</TD><TD>RE_ACT_AMOUNT</TD><TD>REFUND_AMOUNT</TD></TR><TR><TD>02CO1A009498</TD><TD>09 Jan 2019</TD><TD>REFUND</TD><TD>-</TD><TD>1,575</TD></TR><TR><TD>CO2016CF0021559</TD><TD>05 Jan 2019</TD><TD>REFUND</TD><TD>-</TD><TD>25,500</TD></TR><TR><TD>CO2016CF0021559</TD><TD>29 Jan 2019</TD><TD>ADDITIONAL</TD><TD>25,500</TD><TD>&nbsp;</TD></TR><TR><TD>CO2016CF0021564</TD><TD>06 Jan 2019</TD><TD>REFUND</TD><TD>-</TD><TD>4,150</TD></TR><TR><TD>CO2016CF0021564</TD><TD>29 Jan 2019</TD><TD>ADDITIONAL</TD><TD>4,150</TD><TD>&nbsp;</TD></TR><TR><TD>CO2016CF0021572</TD><TD>11 Jan 2019</TD><TD>REFUND</TD><TD>-</TD><TD>6,500</TD></TR><TR><TD>CO2016CF0021572</TD><TD>29 Jan 2019</TD><TD>ADDITIONAL</TD><TD>6,500</TD><TD>&nbsp;</TD></TR><TR><TD>CO2016CF0021598</TD><TD>29 Jan 2019</TD><TD>REFUND</TD><TD>-</TD><TD>4,075</TD></TR><TR><TD>CO2016CF0021598</TD><TD>12 Jan 2019</TD><TD>ADDITIONAL</TD><TD>4,075</TD><TD>&nbsp;</TD></TR><TR><TD>CO2016CF0021997</TD><TD>10 Jan 2019</TD><TD>&nbsp;</TD><TD>314,914</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I WANT FOLLOWING CONDITION</P><P>[TYPE =&nbsp;REFUND,POLICY_NO,MARKETING_DATE]=&lt;[TYPE = ADDITIONAL,POLICY_NO,MARKETING_DATE] AS RE_ACTIVE</P><P>SAGARA</P> Sat, 16 Nov 2024 04:08:34 GMT https://community.qlik.com/t5/QlikView/condition/m-p/1557627#M743124 sagaraperera 2024-11-16T04:08:34Z https://community.qlik.com/t5/QlikView/condition/m-p/1558392#M743127 <P>Perhaps this?</P><P><STRONG>Sum({&lt;MARKETING_DATE = {"=Sum(REFUND_AMOUNT)&lt;=Sum(RE_ACT_AMOUNT)"}&gt;} REFUND_AMOUNT)</STRONG></P> Tue, 19 Mar 2019 11:34:17 GMT https://community.qlik.com/t5/QlikView/condition/m-p/1558392#M743127 Anil_Babu_Samineni 2019-03-19T11:34:17Z