Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagaraperera
Creator
Creator

condition

Dear Mr.SUNNY

PLEASE ADVISE ME A FORMULA TO OBTAIN THE REFUND_AMOUNT,  IF THE MARKETING_DATE OF THE REFUND_AMOUNT HAS EXCEEDED THE  MARKETING_DATE OF THE “RE_ACT_AMOUNT”  IN  A SAME POLICY.

 

My excels file

POLICY_NOMARKETING_DATETYPERE_ACT_AMOUNTREFUND_AMOUNT
02CO1A00949809 Jan 2019REFUND-1,575
CO2016CF002155905 Jan 2019REFUND-25,500
CO2016CF002155929 Jan 2019ADDITIONAL25,500 
CO2016CF002156406 Jan 2019REFUND-4,150
CO2016CF002156429 Jan 2019ADDITIONAL4,150 
CO2016CF002157211 Jan 2019REFUND-6,500
CO2016CF002157229 Jan 2019ADDITIONAL6,500 
CO2016CF002159829 Jan 2019REFUND-4,075
CO2016CF002159812 Jan 2019ADDITIONAL4,075 
CO2016CF002199710 Jan 2019 314,914 
     
     

 

I WANT FOLLOWING CONDITION

[TYPE = REFUND,POLICY_NO,MARKETING_DATE]=<[TYPE = ADDITIONAL,POLICY_NO,MARKETING_DATE] AS RE_ACTIVE

SAGARA

Labels (1)
1 Reply
Anil_Babu_Samineni

Perhaps this?

Sum({<MARKETING_DATE = {"=Sum(REFUND_AMOUNT)<=Sum(RE_ACT_AMOUNT)"}>} REFUND_AMOUNT)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)