topic Re: Finding Max in App Development https://community.qlik.com/t5/App-Development/Finding-Max/m-p/1445629#M35100 <HTML><HEAD></HEAD><BODY><P>‌This</P><P></P><P><STRONG>=if(Sum(Measure)=Max(<SPAN style="color: #ff0000;">TOTAL &lt;Dim1&gt;</SPAN>Aggr(Sum(Measure),Dim1,Dim2)),'Max')</STRONG></P></BODY></HTML> Fri, 22 Dec 2017 02:49:58 GMT sunny_talwar 2017-12-22T02:49:58Z Finding Max https://community.qlik.com/t5/App-Development/Finding-Max/m-p/1445628#M35099 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Brain freeze here! How do I find and mark the Max for each Dim1? How do I reduce the scope?</P><P>=if(Sum(Measure)=Max(Aggr(Sum(Measure),Dim1,Dim2)),'Max')</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187931_Untitled.png" style="height: 394px; width: 620px;" /></P></BODY></HTML> Fri, 22 Dec 2017 01:17:27 GMT https://community.qlik.com/t5/App-Development/Finding-Max/m-p/1445628#M35099 luismadriz 2017-12-22T01:17:27Z Re: Finding Max https://community.qlik.com/t5/App-Development/Finding-Max/m-p/1445629#M35100 <HTML><HEAD></HEAD><BODY><P>‌This</P><P></P><P><STRONG>=if(Sum(Measure)=Max(<SPAN style="color: #ff0000;">TOTAL &lt;Dim1&gt;</SPAN>Aggr(Sum(Measure),Dim1,Dim2)),'Max')</STRONG></P></BODY></HTML> Fri, 22 Dec 2017 02:49:58 GMT https://community.qlik.com/t5/App-Development/Finding-Max/m-p/1445629#M35100 sunny_talwar 2017-12-22T02:49:58Z Re: Finding Max https://community.qlik.com/t5/App-Development/Finding-Max/m-p/1445630#M35101 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187932_Untitled.png" style="height: 391px; width: 620px;" /></P></BODY></HTML> Fri, 22 Dec 2017 02:55:29 GMT https://community.qlik.com/t5/App-Development/Finding-Max/m-p/1445630#M35101 luismadriz 2017-12-22T02:55:29Z