Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
If i understood correctly may be this :
=count({<SalesDate={">$(=date(today()))"}>} distinct SalesDate)
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.
can you share a sample data ?
this is a sample data, I'm trying to count the max([salesdate]) > today() ...
Help!!!
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';
Still not working for me for my version of Qlik, keeps returning 0
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