Need Help: Get Max Date and Max Value of a ID

[panwipa2528]

It's possible to get a max value of a max date of one ID using expressions in QlikView?

Table:

ID	Date	truck_license
1	30/9/2016	AB-9332
1	22/9/2016	EE15
2	21/9/2016	QQ-3346
2	24/9/2016	1CC-351
3	1/9/2016	CC-1783
3	2/9/2016	ASD18
4	22/9/2016	AA-2351
4	23/9/2016	VBV0

Result:

ID	Date	truck_license
1	30/9/2016	AB-9332
2	24/9/2016	1CC-351
3	2/9/2016	ASD18
4	23/9/2016	VBV0

[ecolomer]

Use FirstSortedValue expression in the script to have it

[tresesco]

Straight table

Dim : ID

Exp1: Date(Max(Date))

Exp2: FirstSortedValue(truck_license, -Date)

[panwipa2528]

Thank you very much.

[panwipa2528]

Thank you very much for your help.