topic Time field showing incorrectly in QlikView

Time field showing incorrectly

Tue, 17 Dec 2013 12:03:52 GMT

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

Re: Time field showing incorrectly

swuehl — Tue, 17 Dec 2013 12:05:19 GMT

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

=interval(closedate-logdate)

Re: Time field showing incorrectly

tresB — Tue, 17 Dec 2013 12:07:08 GMT

Try with interval(), like:

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

Re: Time field showing incorrectly

nilesh_gangurde — Tue, 17 Dec 2013 12:08:16 GMT

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