Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Use FirstSortedValue expression in the script to have it
Straight table
Dim : ID
Exp1: Date(Max(Date))
Exp2: FirstSortedValue(truck_license, -Date)
Thank you very much.
Thank you very much for your help.