2 Replies Latest reply: Aug 29, 2013 3:49 PM by Nicole Smith RSS

    Using MAX in a LOAD statement

    Robert Fishel

      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.