Discussion Board for collaboration on QlikView Scripting.
I have a scenario where an order can have multiple certificates, but in the result set I wish to see most recent cert corresponding to the order based on start_date. Please see data below for 2 orders, I should be able to pick the highlighted data.
Please help. Thank you Much in advance
Create a chart with dimension Order_ID and as expression
=FirstSortedValue( CERT_ID, -Start_date)
where start date must have a numeric representation (i.e. like a QV date as a dual value).
Try with FirstSortedValue()
FirstSortedValue( CERT_ID, -Start_date)