topic Max function doubt in QlikView https://community.qlik.com/t5/QlikView/Max-function-doubt/m-p/796302#M1033765 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a code which gives the name of the metric corresponding to the max value change among 20 metrics.</P><P>The code is:</P><P><SPAN style="font-size: 10pt;">=</SPAN><SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff; font-size: 10pt;">MaxString</SPAN><SPAN style="font-size: 10pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 10pt;">MTA_Change</SPAN><SPAN style="font-size: 10pt;">={'$(=max(MTA_Change,1))'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 10pt;">Metric</SPAN></SPAN><SPAN style="font-size: 10pt;"><SPAN style="font-size: 10pt;">)</SPAN> </SPAN></SPAN></P><P></P><P> The problem I'm facing is that if there are two metrics with the same MTA_change then the code is not working. I want the 1st metric to be shown when the rank is 1 and the second metric when the rank is 2.</P><P></P><P>Can anybody help on this?</P></BODY></HTML> Fri, 30 Jan 2015 13:45:42 GMT 2015-01-30T13:45:42Z Max function doubt https://community.qlik.com/t5/QlikView/Max-function-doubt/m-p/796302#M1033765 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a code which gives the name of the metric corresponding to the max value change among 20 metrics.</P><P>The code is:</P><P><SPAN style="font-size: 10pt;">=</SPAN><SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff; font-size: 10pt;">MaxString</SPAN><SPAN style="font-size: 10pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 10pt;">MTA_Change</SPAN><SPAN style="font-size: 10pt;">={'$(=max(MTA_Change,1))'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 10pt;">Metric</SPAN></SPAN><SPAN style="font-size: 10pt;"><SPAN style="font-size: 10pt;">)</SPAN> </SPAN></SPAN></P><P></P><P> The problem I'm facing is that if there are two metrics with the same MTA_change then the code is not working. I want the 1st metric to be shown when the rank is 1 and the second metric when the rank is 2.</P><P></P><P>Can anybody help on this?</P></BODY></HTML> Fri, 30 Jan 2015 13:45:42 GMT https://community.qlik.com/t5/QlikView/Max-function-doubt/m-p/796302#M1033765 2015-01-30T13:45:42Z