Qlik Sense - Counting "Yes" in a column from only Max Date records

[Anonymous]

I have been struggling on how to get this to work for me. I want to count the number of "Managers" in a column titled "Manager - y" from only those records sets where the "Actual Date" field is from the max date. Several records are imported at the same time, so all have the same Max date.

Can only help me with what this should look like?

[devarasu07]

Hi,

you can try like below,

Count (distinct  {$< Managers= {'Manager - y'},Date ={"$(Max(Date))"}>} Managers)

if not working, can you share the mock data and expected output in excel format. thanks

Regards,Deva

[agigliotti]

maybe you can use the below expression:

Count(  {<  [Actual Date] = {"$(=Max([Actual Date]))"} >} DISTINCT [Manager - y] )