Qlik Sense

[abTech]

i wanted to calculate the rate with a condition to pick the max date,, the rate are usually updated,

i have tried this but didn't work:

num(max({<Customer_ID= {'1'}, Satisfaction_rate_date={"$(=Date(max(Satisfaction_rate_date)))"}>} [Satisfaction rate]), '0.0%')

[Venus]

aggr function might be helpful 

[simsa]

num(max({<Customer_ID= {'1'}, Satisfaction_rate_date={"$(=Date(max(TOTAL Satisfaction_rate_date)))"}>} [Satisfaction rate]), '0.0%')