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

    Qlikview - how to compare timestamp diff with constant

    Andrea Gigliotti

      Hello,

       

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

       

      ex.

      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.

       

      BR

      Andrea