Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Time field showing incorrectly

Hi,

I have an issue with a time field.  I am trying to compare log date (eg: 01/11/2013) against the closed date (eg: 27/11/2013).  The expressions shows as such: =Time(closedate-logdate).  This gives me my backlog in hours, however as per the above example, it shows as 05:19:21 instead of showing as  600:00:00 hours (as an example)

Regards,

Jon Ditchfield

1 Solution

Accepted Solutions
swuehl
Not applicable

Re: Time field showing incorrectly

Use interval() instead of time() to format time intervals exceeding 24 hours:

=interval(closedate-logdate)

3 Replies
swuehl
Not applicable

Re: Time field showing incorrectly

Use interval() instead of time() to format time intervals exceeding 24 hours:

=interval(closedate-logdate)

tresesco
Not applicable

Re: Time field showing incorrectly

Try with interval(), like:

interval(closedate-logdate , 'hh:mm')            // you can define your format (hour/min) as expected

nilesh_gangurde
Not applicable

Re: Time field showing incorrectly

Hii,

If you subrtact the Directly (closedate-logdate) , it will give u the difference in Days. those days you have to convert into Hours.

hence the output is showing wrong results.

-Nilesh