Count Max Dates greater than today

[laf4t]

I have a little problem, I am trying to count max date greater than today in qliksense using an expression and I haven't been able to figure it out. What I have is 

=COUNT (DISTINCT Aggr(IF(Max([SalesDate]) > today(),[SalesDate]) ,[SalesDate]))

but this definitely is not giving me the accurate count. Help!!

[Taoufiq_Zarra]

If i understood correctly may be this :

=count({<SalesDate={">$(=date(today()))"}>} distinct SalesDate)

[laf4t]

Thanks but that didn't work, it came back as 0. 

I've also tried this 

=COUNT (DISTINCT Aggr(IF(Max([SalesDate]) > today(),[SalesDate]) ,[SalesDate]))

but it gave me the wrong # of counts, returned 56 instead of 79 .. not sure where I am going wrong.

[Taoufiq_Zarra]

can you share a sample data ?

[laf4t]

this is a sample data, I'm trying to count the max([salesdate]) > today()  ...

Help!!!

[Taoufiq_Zarra]

the formula already sent is correct unless you have some other info to share, otherwise:

=count({<[Sales Date]={">$(=date(today()))"}>} distinct [Sales Date])

output :

3=6/12,6/13 and 6/14

verify also that : SET DateFormat='M/D/YYYY';

[laf4t]

Still not working for me for my version of Qlik, keeps returning 0

[laf4t · Accepted solution]

I was able to tweak what you gave and this worked for me

Count({$<[Sales Date] = {">=$(=Date(Today(), 'YYYY-MM-DD'))"}>} distinct[Client ID])

Thanks everyone