Discussion Board for collaboration on QlikView Scripting.
I wanted to load Max(INVOICE_ID) as MaxID since my requirement is to get the DESCRIPTION of latest INVOICE_ID grouped by VENDOR_NAME.
Requirement is to get latest description of the invoice vendor wise.
Date(INVOICE_DATE,'DD/MM/YYYY') as INVOICE_DATE,
Date(ACCOUNTING_DATE,'DD/MM/YYYY') as ACCOUNTING_DATE,
Go to Solution.
Do it in the from end, like:
Chart: Straight table
Expression: =FirstSortedValue(DESCRIPTION, - INVOICE_ID) // Note, '-' sign