topic Re: Only Max Value by a Dimension in App Development https://community.qlik.com/t5/App-Development/Only-Max-Value-by-a-Dimension/m-p/98168#M6533 <HTML><HEAD></HEAD><BODY><P>Hi Mark,</P><P></P><P>try to use this expression instead of your dimension:</P><P>=if(%_of_sales=aggr(max(total %_of_sales),company),company)</P><P></P><P>BR,<BR />Maria</P></BODY></HTML> Fri, 21 Sep 2018 15:15:20 GMT JaMajka1 2018-09-21T15:15:20Z Only Max Value by a Dimension https://community.qlik.com/t5/App-Development/Only-Max-Value-by-a-Dimension/m-p/98167#M6532 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a table </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Company</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>% of Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">Company A</TD><TD style="padding: 2px;">.5</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Company B</SPAN></TD><TD style="padding: 2px;">.25</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Company C</SPAN></TD><TD style="padding: 2px;">.25</TD></TR></TBODY></TABLE><P></P><P>My expression for % of Sales is Max(Aggr(Sum(Sales)/Sum(Total Sales),Company))&nbsp; which I was hoping would return only one row which shows the company with the highest % of Sales such as below.</P><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Company</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>% of Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">Company A</TD><TD style="padding: 2px;">.5</TD></TR></TBODY></TABLE><P></P><P></P><P>Does anyone know how to accomplish what I am looking for?</P><P></P><P>Thanks,</P><P>Mark</P></BODY></HTML> Sat, 16 Nov 2024 07:36:43 GMT https://community.qlik.com/t5/App-Development/Only-Max-Value-by-a-Dimension/m-p/98167#M6532 m_perreault 2024-11-16T07:36:43Z Re: Only Max Value by a Dimension https://community.qlik.com/t5/App-Development/Only-Max-Value-by-a-Dimension/m-p/98168#M6533 <HTML><HEAD></HEAD><BODY><P>Hi Mark,</P><P></P><P>try to use this expression instead of your dimension:</P><P>=if(%_of_sales=aggr(max(total %_of_sales),company),company)</P><P></P><P>BR,<BR />Maria</P></BODY></HTML> Fri, 21 Sep 2018 15:15:20 GMT https://community.qlik.com/t5/App-Development/Only-Max-Value-by-a-Dimension/m-p/98168#M6533 JaMajka1 2018-09-21T15:15:20Z