topic Sum(amount) on one line in QlikView

Sum(amount) on one line

maxime66 — Wed, 25 Nov 2020 16:16:04 GMT

Hy Qlikers,

I would like to calculte amount of sales when policy is subscribed after the last meeting date (for each customer).

See exemple below of my expected crosstable. (i need to put some zero on other lines)

Thanks by advance

Re: Sum(amount) on one line

sunny_talwar — Mon, 03 Oct 2016 14:47:53 GMT

May be this:

=Sum(Aggr(If(date_meeting - date_pol = Max(TOTAL <id_cust> Aggr(If(date_meeting - date_pol <= 0, date_meeting - date_pol), id_cust, date_meeting, date_pol)), amount, 0), id_cust, date_meeting, date_pol))