Using MAX in a LOAD statement

[Anonymous]

Hello.  This is a bit of code that has me stumped.  In an Access query I have the following statement, which I am trying to rewrite in QlikView.

Access:

Max(IIf(PKORD00_DATA.START_SHIP_DATE=0,Date(),PKORD00_DATA.START_SHIP_DATE)) AS START_SHIP_DATE

What do you use instead of Max in QlikView?  Thanks.

[Clever_Anjos · Accepted solution]

If you want maximum of 2 values use rangemax(value1,value2)

If you want maximum of a field is as you write above

[Nicole-Smith]

If you're using max in the load script, you will also need to use a group by clause.