topic Re: Aggr/Max Question in QlikView https://community.qlik.com/t5/QlikView/Aggr-Max-Question/m-p/722872#M538415 <HTML><HEAD></HEAD><BODY><P>maybe</P><P>=sum(aggr(FirstSortedValue(TOTAL &lt;ID&gt; Value, -StdDay),ID) )</P></BODY></HTML> Fri, 05 Sep 2014 17:39:06 GMT maxgro 2014-09-05T17:39:06Z Aggr/Max Question https://community.qlik.com/t5/QlikView/Aggr-Max-Question/m-p/722870#M538413 <HTML><HEAD></HEAD><BODY><P>I have a data set similar to this:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="274" style="height: 268px; width: 407px;"><TBODY><TR><TD class="xl63" height="17" width="64">ID</TD><TD class="xl63" style="border-left: none;" width="64">Date</TD><TD class="xl63" style="border-left: none;" width="92">StdDay</TD><TD class="xl63" style="border-left: none;" width="64">Value</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">1/1/2014</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">1/2/2014</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">A</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1/3/2014</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">B</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">3/5/2014</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">200</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">B</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3/6/2014</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">C</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">4/1/2014</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">500</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">C</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">4/2/2014</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">400</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">C</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">4/3/2014</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">C</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">4/4/2014</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">C</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">4/5/2014</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">40</TD></TR></TBODY></TABLE><P></P><P>I need a formula that would return the sum of the 'Value' for the maximum 'StdDay' for each 'ID'.&nbsp; The result for this example should be 5+50+40 = 95.&nbsp; </P><P></P><P>Any ideas?</P><P></P><P>Thanks</P></BODY></HTML> Fri, 05 Sep 2014 16:41:13 GMT https://community.qlik.com/t5/QlikView/Aggr-Max-Question/m-p/722870#M538413 2014-09-05T16:41:13Z Re: Aggr/Max Question https://community.qlik.com/t5/QlikView/Aggr-Max-Question/m-p/722871#M538414 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P><STRONG>sum(aggr(firstsortedValue(Value, -StdDay), ID))</STRONG></P><P></P><P>Hope this helps!</P></BODY></HTML> Fri, 05 Sep 2014 17:30:09 GMT https://community.qlik.com/t5/QlikView/Aggr-Max-Question/m-p/722871#M538414 jerem1234 2014-09-05T17:30:09Z Re: Aggr/Max Question https://community.qlik.com/t5/QlikView/Aggr-Max-Question/m-p/722872#M538415 <HTML><HEAD></HEAD><BODY><P>maybe</P><P>=sum(aggr(FirstSortedValue(TOTAL &lt;ID&gt; Value, -StdDay),ID) )</P></BODY></HTML> Fri, 05 Sep 2014 17:39:06 GMT https://community.qlik.com/t5/QlikView/Aggr-Max-Question/m-p/722872#M538415 maxgro 2014-09-05T17:39:06Z Re: Aggr/Max Question https://community.qlik.com/t5/QlikView/Aggr-Max-Question/m-p/722873#M538416 <HTML><HEAD></HEAD><BODY><P>Both answer are ok</P><P>Attached the QV</P></BODY></HTML> Fri, 05 Sep 2014 17:50:07 GMT https://community.qlik.com/t5/QlikView/Aggr-Max-Question/m-p/722873#M538416 ecolomer 2014-09-05T17:50:07Z