Pick one of a duplicate

[anders_smith]

Hi!

Our plans, are beeing saved according to specific frequencies.  When a plan is adjusted between two savings, we will get to records with the same id, but different attributes.  I pick the value that have the latest saving-date:

Only( {$<Created={"=Aggr(Max(SavedDate),PlanId)"}>} PlanDate )

This returns one of the PlanDates, but not nesecarrry the latest saved.

Anyone than can help?

[IAMDV · Accepted solution]

Hi,

Have you tried using FirstSortedValue() function? Probably something like this...

=FirstSortedValue(PlanDates, - Created)

Thanks,

DV

www.QlikShare.com

[anders_smith]

Thank you, Deepak.  Worked fine.

Anders