topic Pick the greater of two values (Max Function) in QlikView

Pick the greater of two values (Max Function)

Fri, 30 Aug 2013 17:57:58 GMT

I'm writing an expression where I want to use the greater of two values. I don't think the Max() expression works like I'm used to. Is there a different function to use?

An if statement like this would work, but the problem is that "value" is 6 lines of code that I'd end up having to repeat two times.

If( value > 0, value, 0)

I'd much rather have a function like this

max(value, 0) so that I only write "value" once.

Any ideas? Thanks!

Re: Pick the greater of two values (Max Function)

tresB — Fri, 30 Aug 2013 18:02:57 GMT

Use RangeMax() function. Like:

RangeMax(Value,0)

Re: Pick the greater of two values (Max Function)

Clever_Anjos — Fri, 30 Aug 2013 18:04:43 GMT

RANGEMAX(value1,value2)