Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max value of variables or an array

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.

10 Replies
sunny_talwar

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