2 Replies Latest reply: Sep 23, 2016 12:15 PM by Andrea Gigliotti RSS

    Qlikview - how to compare timestamp diff with constant

    Andrea Gigliotti



      I need to check if a timestamp difference is equal or greater than a number of hours and minutes.



      I have two timestamp:

      01/01/2015 12:40

      01/01/2015 12:05


      I have to check if the difference of those 2 dates is >= 4 hours and 30 minutes


      in this example I expected to get 35 minutes as time difference that is < of 4 hours and 30 minutes


      How can I achieve it ?


      Many thanks in advance.