topic How to get position of max value based on rangemax in App Development https://community.qlik.com/t5/App-Development/How-to-get-position-of-max-value-based-on-rangemax/m-p/2086405#M89075 <P>Hi,</P> <P>&nbsp;</P> <P>Using rangemax ,I have got the max value from multiple fields.</P> <P>expression used : rangemax(field1,field2,field3)</P> <P>How to get the field of the max value present in the rangemax?</P> <P>For eg: here if field1 is max value,I want to get output as 'field1' and not the value of that field1.</P> Wed, 21 Jun 2023 15:21:49 GMT Ameya09 2023-06-21T15:21:49Z How to get position of max value based on rangemax https://community.qlik.com/t5/App-Development/How-to-get-position-of-max-value-based-on-rangemax/m-p/2086405#M89075 <P>Hi,</P> <P>&nbsp;</P> <P>Using rangemax ,I have got the max value from multiple fields.</P> <P>expression used : rangemax(field1,field2,field3)</P> <P>How to get the field of the max value present in the rangemax?</P> <P>For eg: here if field1 is max value,I want to get output as 'field1' and not the value of that field1.</P> Wed, 21 Jun 2023 15:21:49 GMT https://community.qlik.com/t5/App-Development/How-to-get-position-of-max-value-based-on-rangemax/m-p/2086405#M89075 Ameya09 2023-06-21T15:21:49Z Re: How to get position of max value based on rangemax https://community.qlik.com/t5/App-Development/How-to-get-position-of-max-value-based-on-rangemax/m-p/2086424#M89078 <P>It's a bit awkward looking, but this seems to work:</P> <P class="p1"><FONT face="courier new,courier"><SPAN class="s1">Pick</SPAN>(<SPAN class="s1">Match</SPAN>(<SPAN class="s1">RangeMax</SPAN>(<SPAN class="s2">F1</SPAN>, <SPAN class="s2">F2</SPAN>, <SPAN class="s2">F3</SPAN>), <SPAN class="s2">F1</SPAN>, <SPAN class="s2">F2</SPAN>, <SPAN class="s2">F3</SPAN>), 'F1', 'F2', 'F3')</FONT></P> <P class="p1">-Rob<BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A><BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A></P> Wed, 21 Jun 2023 15:56:34 GMT https://community.qlik.com/t5/App-Development/How-to-get-position-of-max-value-based-on-rangemax/m-p/2086424#M89078 rwunderlich 2023-06-21T15:56:34Z