Date count not coming properly for past 30 days from today

[saivina2920]

EMP_RELIEVE_DATE
--------------------------
13/07/2020
24/07/2020
07/08/2020

=count(DISTINCT if((Date(EMP_RELIEVE_DATE,'DD/MM/YYYY') - Today() and Date(EMP_RELIEVE_DATE,'DD/MM/YYYY') - Today() > 20) ),EMP_RELIEVE_DATE))

i am getting count people who are relieving from today and past more than 30 days

I have 3 records in that count. but, I am getting "zero" count

what is the problem in the expressions.

=count(DISTINCT if((Date(EMP_RELIEVE_DATE,'DD/MM/YYYY') - Today() and Date(EMP_RELIEVE_DATE,'DD/MM/YYYY') - Today() > 30) ),EMP_RELIEVE_DATE))

[saivina2920]

can anyone check the file and give us the correct count..this is urgent and i am waiting..

[MayilVahanan]

Hi @saivina2920 

Kush already replied to this one..

https://community.qlik.com/t5/New-to-QlikView/Date-count-not-coming-properly-for-past-10-days-and-10...

Hope it helps you