Dynamic Filter qlik sense maximum date

[naishaansh]

I have a filter titled ID. I need to chose the latest value on ID filter based on a maximum date. 

My data set looks like this 

Date              ID

2022/12/17  3

2022/12/17  4

2022/12/17  5

2022/11/25  1

2022/11/25 9

So when the  ID column is displayed on the table, I need to write a set analysis expression that it should always  give dynamically the results.

In this case it should display 5 because 5 is the maximum value for ID since the maximum date is 2022.12.17. 

How do I write set analysis? I tried many but didn't work

[BrunPierre · Accepted solution]

=Max({<Date={"$(=Max(Date))"}>}ID)

[naishaansh]

Thanks.