Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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.

Labels (1)
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))