Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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?

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Luminary
Luminary

Re: Pick one of a duplicate

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
Highlighted
Luminary
Luminary

Re: Pick one of a duplicate

Hi,

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

=FirstSortedValue(PlanDates, - Created)

Thanks,

DV

www.QlikShare.com

View solution in original post

Highlighted
Contributor II
Contributor II

Pick one of a duplicate

Thank you, Deepak.  Worked fine.

Anders