Highlight minimum Rank Dynamically

[Qlikuser225]

Hello Everyone,

Can anyone please help me with below case

ID     Date            Rank

23    01/01/2024    1

23    01/01/2024    2

23    01/02/2024    3

23    01/02/2024    4

24    01/01/2024    1

24    01/01/2024    2

24    01/02/2024    3

I want to highlight where Rank is minimum with the date range for example - 

23    01/01/2024    1

24    01/01/2024    1

Here i want to highlight (background color) above Rows since they have minimum Rank, but when user select date 01/02/20204 then i want to highlight below rows since they have minimum rank per that date

23    01/02/2024    3

24    01/01/2024    2

Thanks in Advance

[Sayed_Mannan · Accepted solution]

Try this code in the background color expression under the Rank dimension,

if(Rank = min(total <Date> Rank), RGB(169,208,142), white())