https://community.qlik.com/t5/App-Development/How-to-get-max-value-using-aggr-function/m-p/1536248#M40360 Use this expression for Sales measure:<BR />Sum(Aggr(Max(Sales), Product, Date)) Tue, 29 Jan 2019 00:41:02 GMT Lisa_P 2019-01-29T00:41:02Z https://community.qlik.com/t5/App-Development/How-to-get-max-value-using-aggr-function/m-p/1536131#M40359 <P>Hi experts,</P><P>how to get max values on each date of each product and sum of each date values</P><P>the result should be like this</P><P>Answer:</P><P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.PNG" style="width: 138px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4652i7EC3701CCCA084EA/image-size/large?v=v2&amp;px=999" role="button" title="Capture1.PNG" alt="Capture1.PNG" /></span></P><P>Question :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture2.PNG" style="width: 201px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4653i1F18C40949B7D5B6/image-size/large?v=v2&amp;px=999" role="button" title="Capture2.PNG" alt="Capture2.PNG" /></span></P> Mon, 28 Jan 2019 18:17:19 GMT https://community.qlik.com/t5/App-Development/How-to-get-max-value-using-aggr-function/m-p/1536131#M40359 rajaqliks 2019-01-28T18:17:19Z https://community.qlik.com/t5/App-Development/How-to-get-max-value-using-aggr-function/m-p/1536248#M40360 Use this expression for Sales measure:<BR />Sum(Aggr(Max(Sales), Product, Date)) Tue, 29 Jan 2019 00:41:02 GMT https://community.qlik.com/t5/App-Development/How-to-get-max-value-using-aggr-function/m-p/1536248#M40360 Lisa_P 2019-01-29T00:41:02Z