Select a record with the latest date in qlikview

[#1]

How, Select a record with the latest date in qlikview helpme thanks

[jagan]

Hi,

Can you explain you requirement little bit detailed.

Regards,

Jagan.

[#3]

Hi Rolan,

Check the following expression

=FirstSortedValue(Field1&'  '&field2, -Date)

for instance if you have OrderID,OrderDate & Name in your table and if you want to show the OrderID&Name based on the latest OrderDate then

=FirstSortedValue(OrderID&'  '&Name, -Date) then it will show the ID & Name based on the latest date. don't forget to put - bfore date.

Hope it helps.

Regards,

Arun Prasadh.N.

[#4]

Hi Rolan,

If u get confused with my explanation jst take this expression only.

=FirstSortedValue(Field1, -Datefield)

It works perfectly.