topic Is there a function for biggest ? in QlikView

Is there a function for biggest ?

Anonymous — Tue, 04 Nov 2014 13:24:30 GMT

Is there a function for biggest ?

What I am after is something that if I have 3 variables set say like this :

set vSmall = 1 ;

set vMedium = 22 ;

set vBig = 333 ;

Then my imaginary Biggest() function when used like this :

Biggest ( vMedium , vBig , vSmall )

Would return the value of vBig as it is the biggest, as in 333

Many Thanks, Bill

Anonymous — Tue, 04 Nov 2014 13:30:19 GMT

Bill,

Use the Rangemax(value1, value2,...) function.

Marc.

Anonymous — Tue, 04 Nov 2014 13:36:57 GMT

Wow !! Perfect !!

Many Thanks, Bill