Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pthomas3253
New Contributor II

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

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?

2 Replies
devarasu07
Honored Contributor II

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

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
Honored Contributor II

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

maybe you can use the below expression:

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

Community Browser