topic Re: Using MAX in a LOAD statement in QlikView https://community.qlik.com/t5/QlikView/Using-MAX-in-a-LOAD-statement/m-p/549921#M690993 <HTML><HEAD></HEAD><BODY><P>If you're using max in the load script, you will also need to use a group by clause.</P></BODY></HTML> Thu, 29 Aug 2013 19:49:30 GMT Nicole-Smith 2013-08-29T19:49:30Z Using MAX in a LOAD statement https://community.qlik.com/t5/QlikView/Using-MAX-in-a-LOAD-statement/m-p/549919#M690991 <HTML><HEAD></HEAD><BODY><P>Hello.&nbsp; This is a bit of code that has me stumped.&nbsp; In an Access query I have the following statement, which I am trying to rewrite in QlikView.</P><P></P><P>Access:</P><P>Max(IIf(PKORD00_DATA.START_SHIP_DATE=0,Date(),PKORD00_DATA.START_SHIP_DATE)) AS START_SHIP_DATE</P><P></P><P>What do you use instead of Max in QlikView?&nbsp; Thanks.</P></BODY></HTML> Thu, 29 Aug 2013 19:06:09 GMT https://community.qlik.com/t5/QlikView/Using-MAX-in-a-LOAD-statement/m-p/549919#M690991 Anonymous 2013-08-29T19:06:09Z Re: Using MAX in a LOAD statement https://community.qlik.com/t5/QlikView/Using-MAX-in-a-LOAD-statement/m-p/549920#M690992 <HTML><HEAD></HEAD><BODY><P>If you want maximum of 2 values use rangemax(value1,value2)</P><P>If you want maximum of a field is as you write above</P></BODY></HTML> Thu, 29 Aug 2013 19:43:35 GMT https://community.qlik.com/t5/QlikView/Using-MAX-in-a-LOAD-statement/m-p/549920#M690992 Clever_Anjos 2013-08-29T19:43:35Z Re: Using MAX in a LOAD statement https://community.qlik.com/t5/QlikView/Using-MAX-in-a-LOAD-statement/m-p/549921#M690993 <HTML><HEAD></HEAD><BODY><P>If you're using max in the load script, you will also need to use a group by clause.</P></BODY></HTML> Thu, 29 Aug 2013 19:49:30 GMT https://community.qlik.com/t5/QlikView/Using-MAX-in-a-LOAD-statement/m-p/549921#M690993 Nicole-Smith 2013-08-29T19:49:30Z