Pick(Match()) or may be another function

[sunny_talwar]

Hey Qlikers,

There might be a very easy solution for this, but I am kind of confused on how I can achieve this. I have a formula like this:

=Pick(Match(23, 23, 34, 23, 45), 'R', 'T', 'P', 'K') and when I put this in a text box, I get the output to be R (which makes sense because its matching the first instance of the number to match with and giving me the output R.

What I want is to be able to somehow get the output R, P.

To give some details about what exactly I am doing:

=Pick(Match(MaxfromMultipleFieldsusingRangeMax, MaxField1, MaxField2, MaxField3.....), 'Field1', 'Field2', 'Field3'....)

All the responses are greatly appreciated.

Best,

Sunny

[sunny_talwar]

It did work, made a small error which was causing it to not work. But thanks for introducing this new concept to me.

Best,

Sunny

[sunny_talwar]

Thanks for your response Joe, but in my scenario this wouldn't be very helpful to use this.

Best,

Sunny

[sunny_talwar]

Out of curiosity, can I Give more than one inputs to a function? May be like

vVar = Avg([$1]) - Avg([$2])

and use is like this? $(vVar(Field1, Field2))

[anbu1984]

Yes you can pass more than one argument

[sunny_talwar]

Amazing! Thanks guys

Best,

Sunny