Robuta

https://community.qlik.com/t5/QlikView/Sum-Values-Having-Max-Date/m-p/405311/highlight/true Solved: Re: Sum Values Having Max Date - Qlik Community - 405304 Mar 11, 2020 - Does this work? Can probably be amended to set analysis if you prefer. =sum(Value*if(Date=aggr(nodistinct max(Date), Name),1,0)) flipside - 405304 max dateqlik communitysolvedsumvalues