topic Summing Range Max in QlikView https://community.qlik.com/t5/QlikView/Summing-Range-Max/m-p/263327#M99059 <HTML><HEAD></HEAD><BODY><P>sum(aggr(max(hours),Date))</P></BODY></HTML> Tue, 10 Jan 2012 19:07:12 GMT 2012-01-10T19:07:12Z Summing Range Max https://community.qlik.com/t5/QlikView/Summing-Range-Max/m-p/263326#M99058 <HTML><HEAD></HEAD><BODY><P>I'm trying to sum the greatest number of hours for every day.</P><P></P><P>i.e. I want the sum of the bolded numbers below: 19</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px; border-collapse: collapse;"><TBODY><TR style="height: 15pt;"><TD class="xl64" height="20" style="width: 48pt; height: 15pt;" width="64">Date</TD><TD class="xl64" style="width: 48pt;" width="64">Hours</TD></TR><TR style="height: 15pt;"><TD align="right" class="xl63" height="20" style="height: 15pt;">1/2/2011</TD><TD align="right">2</TD></TR><TR style="height: 15pt;"><TD align="right" class="xl63" height="20" style="height: 15pt;">1/2/2011</TD><TD align="right">3</TD></TR><TR style="height: 15pt;"><TD align="right" class="xl63" height="20" style="height: 15pt;"><STRONG>1/2/2011</STRONG></TD><TD align="right" class="xl65"><STRONG>4</STRONG></TD></TR><TR style="height: 15pt;"><TD align="right" class="xl63" height="20" style="height: 15pt;">1/3/2011</TD><TD align="right">2</TD></TR><TR style="height: 15pt;"><TD align="right" class="xl63" height="20" style="height: 15pt;">1/3/2011</TD><TD align="right">4</TD></TR><TR style="height: 15pt;"><TD align="right" class="xl63" height="20" style="height: 15pt;"><STRONG>1/3/2011</STRONG></TD><TD align="right" class="xl65"><STRONG>9</STRONG></TD></TR><TR style="height: 15pt;"><TD align="right" class="xl63" height="20" style="height: 15pt;">1/3/2011</TD><TD align="right">2</TD></TR><TR style="height: 15pt;"><TD align="right" class="xl63" height="20" style="height: 15pt;">1/4/2011</TD><TD align="right">3</TD></TR><TR style="height: 15pt;"><TD align="right" class="xl63" height="20" style="height: 15pt;"><STRONG>1/4/2011</STRONG></TD><TD align="right" class="xl65"><STRONG>6</STRONG></TD></TR></TBODY></TABLE><P></P><P>I can't sum(max(hours), any other ideas?</P></BODY></HTML> Tue, 10 Jan 2012 19:03:02 GMT https://community.qlik.com/t5/QlikView/Summing-Range-Max/m-p/263326#M99058 2012-01-10T19:03:02Z Summing Range Max https://community.qlik.com/t5/QlikView/Summing-Range-Max/m-p/263327#M99059 <HTML><HEAD></HEAD><BODY><P>sum(aggr(max(hours),Date))</P></BODY></HTML> Tue, 10 Jan 2012 19:07:12 GMT https://community.qlik.com/t5/QlikView/Summing-Range-Max/m-p/263327#M99059 2012-01-10T19:07:12Z