topic Re: Qlikview - how to compare timestamp diff with constant in QlikView

Qlikview - how to compare timestamp diff with constant

agigliotti — Fri, 23 Sep 2016 15:27:13 GMT

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.

Andrea

sunny_talwar — Fri, 23 Sep 2016 15:40:44 GMT

If these are loaded correctly as timestamps, you can just do this

TimeStamp1 - TimeStamp2 >= MakeTime(4, 30)

If not read correctly, then may be this:

TimeStamp#(TimeStamp1, 'MM/DD/YYYY hh:mm') - TimeStamp#(TimeStamp2, 'MM/DD/YYYY hh:mm') >= MakeTime(4, 30)

agigliotti — Fri, 23 Sep 2016 16:15:35 GMT

just the first one worked for me.

Many thanks.