QlikChallenge #1: Getting the max value over multiple expressions

Some days ago I received a funny/tricky question:

Let’s assume you have the following data:

And you want to calculate the highest expression of Value_1, Value_2, etc. within your load script to get the following result:

How would you solve this?
Just use the comment section to post your ideas … I am looking forward to reviewing your solutions … :)


P.S.: Ralph & Team: You are not allowed to participate in this competition because you have already received my solution for that question :)

Bookmark and Share

. Bookmark the permalink. Both comments and trackbacks are currently closed.