topic Maximum Value in QlikView https://community.qlik.com/t5/QlikView/Maximum-Value/m-p/426845#M159033 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I am trying to look at the sum of the maximum sub section.</P><P></P><P>e.g.</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Section</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubSection</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>1a</TD><TD>100</TD></TR><TR><TD>1</TD><TD>1a</TD><TD>10</TD></TR><TR><TD>1</TD><TD>1b</TD><TD>200</TD></TR><TR><TD>1</TD><TD>1c</TD><TD>200</TD></TR><TR><TD>1</TD><TD>1c</TD><TD>10</TD></TR></TBODY></TABLE><P></P><P>So the value i would expect to see would be 210 which is the total of subsection 1c rather than the max the whole section.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Fri, 05 Apr 2013 16:00:55 GMT 2013-04-05T16:00:55Z Maximum Value https://community.qlik.com/t5/QlikView/Maximum-Value/m-p/426845#M159033 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I am trying to look at the sum of the maximum sub section.</P><P></P><P>e.g.</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Section</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SubSection</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>1a</TD><TD>100</TD></TR><TR><TD>1</TD><TD>1a</TD><TD>10</TD></TR><TR><TD>1</TD><TD>1b</TD><TD>200</TD></TR><TR><TD>1</TD><TD>1c</TD><TD>200</TD></TR><TR><TD>1</TD><TD>1c</TD><TD>10</TD></TR></TBODY></TABLE><P></P><P>So the value i would expect to see would be 210 which is the total of subsection 1c rather than the max the whole section.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Fri, 05 Apr 2013 16:00:55 GMT https://community.qlik.com/t5/QlikView/Maximum-Value/m-p/426845#M159033 2013-04-05T16:00:55Z Re: Maximum Value https://community.qlik.com/t5/QlikView/Maximum-Value/m-p/426846#M159034 <HTML><HEAD></HEAD><BODY><P>try:</P><P></P><P>Max(Aggr(sum(value),SubSection))</P><P></P><P>Please find attached</P><P></P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Fri, 05 Apr 2013 16:07:29 GMT https://community.qlik.com/t5/QlikView/Maximum-Value/m-p/426846#M159034 sushil353 2013-04-05T16:07:29Z