5 Replies Latest reply: May 5, 2016 10:34 AM by Onno van Knotsenburg RSS

    End Of Contract Formula

    Ibrahim Qaed

      Dears,

       

      I hope you are well,


      I want to get the End Of Contract result for each employee as shown in the below table:

         

      EmployeeStartDateContract PeriodStatusEnd Of Contract
      John2/7/20022Renewed2/7/2018
      Sergio1/3/20152Renewed1/3/2017
      Michael10/5/20102Renewed10/5/2018
      Sara1/9/20012Renewed1/9/2017
      Joly1/9/19902Renewed1/9/2018
      Boadicea4/17/20142Renewed4/17/2018

       

      The formula for end of contract is :

       

      =DATE(YEAR(B2) + DATEDIF(B2, DATE(2017, MONTH(B2), DAY(B2)), "Y") + ISEVEN(YEAR(B2)), MONTH(B2), DAY(B2))

       

      my issue is that I need to convert this formula to Qlikview logic so I can show this report in QLikview. Or if there is any other formula can do the same that would be fine. 

       

      Can anyone help me out here.

       

      Thanks,

      Ibrahim