topic Re: Time Difference in QlikView

Time Difference

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

please find the attached file.

I have to columns are Closed date,Open date.

I need the exact difference between two days. i need to show them difference in Minutes.

if we have 1 day difference between two days we need to consider 24*60=14440 (Minutes)

Regards

Mahesh

swuehl — Thu, 25 Jan 2018 07:20:58 GMT

You can just subtract the dates (if they were properly interpreted as such) and format:

=Interval(Today()-(Today()-1),'mm')

resp.

=Interval(CloseDate-OpenDate,'mm')

If you need to calculate further with your minutes, use

=(CloseDate-OpenDate) * (24*60)

qlikview979 — Thu, 25 Jan 2018 07:24:34 GMT

Sorry bro,

attachment missed.

I tried it not giving correct result

can u please help me on this?

qlikview979 — Thu, 25 Jan 2018 07:26:33 GMT

Some cases closed date and open date is same

In that case i need only time difference.

-Mahesh

swuehl — Thu, 25 Jan 2018 07:37:13 GMT

If your field values are timestamps instead of dates, it will also work for time difference in minutes.

qlikview979 — Thu, 25 Jan 2018 07:41:02 GMT

Hi Bro,

I tried many way but i am not getting correct result.

its a Urgent requirement can u help on this with my data.

Regards

Mahesh

swuehl — Thu, 25 Jan 2018 08:24:34 GMT

How does your script look like? Are the timestamps interpreted correctly (follow HICs advice in 'why don't my Dates work' to check)?

The format should look like

SET TimestampFormat = 'M/D/YYYY h:mm:ss TT';

LOAD ClosedTime,

OpenTime,

Round((ClosedTime-OpenTime)*(24*60)) as DurationMinutes

FROM ....;