0 Replies Latest reply: Oct 16, 2015 3:50 AM by Alice Sim RSS

    Comparing 2 dates and return the year

      Hi expert,

       

      I'm new to Qlik Sense. I have the below dates as below :-

      • Creation Date
      • Start Date
      • End Date

       

      I would like to compare these 2 dates where if the "Creation Date" is greater or equal to "Start Date" and "Creation Date is lesser or equal to "End Date", return the "Creation Date - Year".

       

      How can i achieve the above by using set analysis?

       

       

      Thanks,

      Alice