Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Highlighted
MVP
MVP

Re: Time field showing incorrectly

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

=interval(closedate-logdate)

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: Time field showing incorrectly

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

=interval(closedate-logdate)

View solution in original post

Highlighted
MVP
MVP

Re: Time field showing incorrectly

Try with interval(), like:

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

Highlighted
Partner
Partner

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