6 Replies Latest reply: Dec 6, 2017 7:41 AM by Eduardo Gallo RSS

    Calculate the difference of months between dates

    Eduardo Gallo

      Hello! I am a beginner in Qlik Sense and would like to calculate the difference between dates as follows:

       

      Pick the highest date recorded for the ID;

      Calculate the difference of months with the current date.

       

      ID
      DATE (MM/DD/YYYY)
      101/10/2017
      104/19/2017
      105/20/2017
      202/10/2017
      203/31/2017
      209/17/2017


      Assuming the current date is 12/4/2017 the expected result would be:


       

      iDMax DateDifference Months
      105/20/20176 Months
      209/17/20173 Months


      Thanks in advance for your attention and help.


      Tks