Show the most recent date

[carlotavendrell95]

Hi all, 

I've got these fields: 

But I want to show only the highest value for each person. As you can see, Carlota has a lot of values. What I've done, is to convert the date to a number. I've tried Max but it does not work.

How can I show an Unique value for each person? I want to show the most recent date!

Thank you!

[Claudiu_Anghelescu]

Dimensions = Name, Date

Expression = aggr(Max(Number),Name)

I made in QlikView but you can adapt in Sense.

[Claudiu_Anghelescu]

Voila in Qlik Sense!