And here is a QVW example of what I mean, where I am using nested if to solve what I need. But in the "real world", I need to compare 10-20 different expressions per dimension, so a solution with nested if is not preferable...there really must be an easier way...
findmax.qvw 150.5 K
Robert Svebeck wrote:
Highest = getmymaxvalue([Expr1],[Expr2],[Expr3],[Expr4])
You're SO close. You want the rangemax() and rangemin() functions, and you can refer to either the column labels or numbers, whichever is more convenient for you. So either of these should work (and do in your example):