topic Re: Sum Value for the max Date for every Customer in QlikView https://community.qlik.com/t5/QlikView/Sum-Value-for-the-max-Date-for-every-Customer/m-p/77701#M769387 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>FirstSortedValue(Aggr(Sum(Value), DateChange, Customer), -Aggr(DateChange, DateChange, Customer))</STRONG></P></BODY></HTML> Fri, 08 Jun 2018 15:30:03 GMT sunny_talwar 2018-06-08T15:30:03Z Sum Value for the max Date for every Customer https://community.qlik.com/t5/QlikView/Sum-Value-for-the-max-Date-for-every-Customer/m-p/77700#M769386 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I have some Customers (Field Customer) and every customer can have some kind of card or even a few cards. For every card, there is a date of last change, e.g. a card can have several dates. I want to sum up how many money (Field money) is left on every card of every customer, but just using the latest date of change. This means if I have dates 2018-05-01 and 2018-06-23, I only want to use the value of the money field, which corresponds to the latest date.</P><P>I try to do this in a text box, but I think I am failing.</P><P>A Set Analysis expression using the max(DateChange) is not the right thing.</P><P>Any suggestions? Is this even possible in a text box?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sum-Value-for-the-max-Date-for-every-Customer/m-p/77700#M769386 Anonymous 2020-11-25T16:16:04Z Re: Sum Value for the max Date for every Customer https://community.qlik.com/t5/QlikView/Sum-Value-for-the-max-Date-for-every-Customer/m-p/77701#M769387 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>FirstSortedValue(Aggr(Sum(Value), DateChange, Customer), -Aggr(DateChange, DateChange, Customer))</STRONG></P></BODY></HTML> Fri, 08 Jun 2018 15:30:03 GMT https://community.qlik.com/t5/QlikView/Sum-Value-for-the-max-Date-for-every-Customer/m-p/77701#M769387 sunny_talwar 2018-06-08T15:30:03Z