Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anders_smith
Contributor II
Contributor II

Pick one of a duplicate

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?

1 Solution

Accepted Solutions
IAMDV
Luminary Alumni
Luminary Alumni

Hi,

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

=FirstSortedValue(PlanDates, - Created)

Thanks,

DV

www.QlikShare.com

View solution in original post

2 Replies
IAMDV
Luminary Alumni
Luminary Alumni

Hi,

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

=FirstSortedValue(PlanDates, - Created)

Thanks,

DV

www.QlikShare.com

anders_smith
Contributor II
Contributor II
Author

Thank you, Deepak.  Worked fine.

Anders