topic Maximum of two expressions in QlikView

Maximum of two expressions

Tue, 28 Dec 2010 12:01:50 GMT

Hi All,

I have a pivot chart in which i have five calculated expressions.

I need to find the maximum of Net Long Positions and Net Short Positions.

I have used the formula,

Max([Net Long Position],[Net Short Position]), but it shows a null value.

Can someone please help and let me know how to get the maximum of the two expressions.

Thanks

sathishkumar_go — Tue, 28 Dec 2010 12:17:45 GMT

HI,

Can u attach ur application here?

-Sathish

Tue, 28 Dec 2010 13:30:14 GMT

HI.

Maybe instead of "max(...)" try "rangemax(...)"

Regards,

Montal.

Tue, 28 Dec 2010 13:58:15 GMT

Hi,

Take a look at function: rangemax ( expr1 [ , expr2, ... exprN ] )

So in your case try: rangemax(Max([Net Long Position]),Max([Net Short Position]))

Kind regards,

Huub

Tue, 28 Dec 2010 14:05:13 GMT

Thanks for your replies but it still doesnt work.

I cant post the file because im open in server.

johnw — Wed, 29 Dec 2010 02:10:29 GMT

Is this a column you're adding to the chart?

rangemax([Net Long Position],[Net Short Position])

Wed, 29 Dec 2010 07:29:32 GMT

Hi Use below functions

rangemax (1,2,4)
returns 4

rangemax (1,'xyz')
returns 1

Wed, 29 Dec 2010 08:06:44 GMT

Yes that's it thanks. Its working now.