topic Re: MAx from from two or fields in script in QlikView

MAx from from two or fields in script

Thu, 08 Jan 2015 14:40:17 GMT

Hi All,

I need to get the max values from multiple columns and want to do this in script.

e.g I have having below columns Col1 to Col4. I want to get another column as MaxValue in the script itself. Please advise

Thanks,

Sijo

rajeshvaswani77 — Thu, 08 Jan 2015 14:42:18 GMT

Preceding load and then if conditions will do the trick.

regards,

Rajesh Vaswani

alexandros17 — Thu, 08 Jan 2015 14:43:32 GMT

Here it is an example

julian_rodriguez — Thu, 08 Jan 2015 14:43:58 GMT

Hello Sijo

Try this:

MyData:

LOAD

Col1,

Col2,

Col3,

Col4,

RangeMax(Col1, Col2, Col3, Col4) AS MaxValue

FROM

MyData.xls

Thu, 08 Jan 2015 14:47:07 GMT

Thanks

Thu, 08 Jan 2015 14:47:19 GMT

Thanks Rajesh

Thu, 08 Jan 2015 14:48:00 GMT

thnaks