Sum where the date is lower than today's date minus 1 year

[#1]

Hello Experts

I am trying to make a field to display the sum of the sales in which the date is lower than today's date minus one year. So far I have been able to write this function:

Sum({<[Date field]={"<=$(Addyears(Today(),-1)"}>} Sales)

But it is not working as it is displaying a null value.

In addition have to say that this may be pretty obvious for sure, but I am kind of new on learning Qlik Sense.

Thanks in advance and regards

[sunny_talwar]

As long as you are not equating (=) and using (<= or >=) time stamp will work, but yes, If you don't really use it, I would suggest getting rid of it using Floor() function in the script

LOAD Date(Floor(Date)) as Date