Discussion Board for collaboration on QlikView Scripting.
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.
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.
Go to Solution.
If you want maximum of 2 values use rangemax(value1,value2)
If you want maximum of a field is as you write above
If you're using max in the load script, you will also need to use a group by clause.