QlikChallenge #1: Getting the max value over multiple expressions

By Stefan Walther Comments closed
This entry was posted in Load Scripts, QlikChallenge

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 … :)

Regards
Stefan

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

Possibly related posts:

  1. qlikblog.at is now published in English!
    About four months ago I have created this blog for sharing my knowledge and ideas about business intelligence and especially QlikView. In the last weeks I have received so many mails! Thanks! But most of...
  2. QlikTip #25: How do you organize your QlikView projects in your file system?
    In the last three years I have quite often changed my standard concept of structuring my (customers’) QlikView projects in the file system. But for about 1 1/2 years “my” concept seems to be stable...
  3. QlikTip #11: Einlesen von Ini-Dateien
    QlikView bietet eine Reihe von Funktionalitäten an, wie man xml-, Excel-, csv-,txt-Dateien, usw. strukturiert einlesen kann. Dieser Tip zeigt, wie man auch .ini-Dateien sinnvoll auslesen kann. “Typische” Ini-Dateien haben folgende Struktur (siehe auch http://en.wikipedia.org/wiki/INI_file): [Section1]...
Bookmark and Share
Published: April 15, 2011
. Bookmark the permalink. Both comments and trackbacks are currently closed.

15 Comments