topic Want to sum a value based on a max date in QlikView https://community.qlik.com/t5/QlikView/Want-to-sum-a-value-based-on-a-max-date/m-p/264678#M1183758 <HTML><HEAD></HEAD><BODY><P>This is going to be easy to most people but I'm new. </P><P></P><P>I want to sum(value) where DaysFilled.Date=Max(DaysFilled.Date)&nbsp; and also $ current selection. </P><P></P><P>Thank you!</P></BODY></HTML> Thu, 20 Oct 2011 22:20:55 GMT 2011-10-20T22:20:55Z Want to sum a value based on a max date https://community.qlik.com/t5/QlikView/Want-to-sum-a-value-based-on-a-max-date/m-p/264678#M1183758 <HTML><HEAD></HEAD><BODY><P>This is going to be easy to most people but I'm new. </P><P></P><P>I want to sum(value) where DaysFilled.Date=Max(DaysFilled.Date)&nbsp; and also $ current selection. </P><P></P><P>Thank you!</P></BODY></HTML> Thu, 20 Oct 2011 22:20:55 GMT https://community.qlik.com/t5/QlikView/Want-to-sum-a-value-based-on-a-max-date/m-p/264678#M1183758 2011-10-20T22:20:55Z Want to sum a value based on a max date https://community.qlik.com/t5/QlikView/Want-to-sum-a-value-based-on-a-max-date/m-p/264679#M1183759 <HTML><HEAD></HEAD><BODY><P>try this:</P><P> sum({$&lt;DaysFilled.Date = {$(=Max(DaysFilled.Date))}&gt;} value)</P></BODY></HTML> Thu, 20 Oct 2011 23:10:44 GMT https://community.qlik.com/t5/QlikView/Want-to-sum-a-value-based-on-a-max-date/m-p/264679#M1183759 2011-10-20T23:10:44Z