Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

thnkgreen
Contributor

Using MAX in a LOAD statement

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.

1 Solution

Accepted Solutions
Employee
Employee

Re: Using MAX in a LOAD statement

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

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

2 Replies
Employee
Employee

Re: Using MAX in a LOAD statement

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

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

Re: Using MAX in a LOAD statement

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

Community Browser