Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am looking for a function that gives me the max value of a set of variables or an array, for example,
vA=1, vB=10, vC=100
unknown function(vA, vB, vC)=100
unknown function( 1, 10, 100)=100
Is there such a function in QlikView? Thanks.
I would probably take the RangeMin route:
=RangeMin(If(RangeMin(vA, vB, vC, vD) = vA, 99999999999, vA), If(RangeMin(vA, vB, vC, vD) = vB, 99999999999,vB), If(RangeMin(vA, vB, vC, vD) = vC, 99999999999, vC), If(RangeMin(vA, vB, vC, vD) = vD, 99999999999, vD))