How to get position of max value based on rangemax

[Ameya09]

Hi,

Using rangemax ,I have got the max value from multiple fields.

expression used : rangemax(field1,field2,field3)

How to get the field of the max value present in the rangemax?

For eg: here if field1 is max value,I want to get output as 'field1' and not the value of that field1.

[rwunderlich · Accepted solution]

It's a bit awkward looking, but this seems to work:

Pick(Match(RangeMax(F1, F2, F3), F1, F2, F3), 'F1', 'F2', 'F3')

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com