10 Replies Latest reply: Apr 14, 2016 7:07 AM by Sunny Talwar RSS

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

    Javier Faces

      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