topic Time problem in QlikView

Time problem

Anonymous — Tue, 11 Dec 2012 18:23:10 GMT

Hi,

I calculated the runtime by the interval(EndTimeStamp - StartTimeStamp) and the result is hh:mm:ss

Now if I do hour(runtime) I get the right value for all the intervals which have hour <= 23

If my interval is longer than 24 hours, the system always display 23. For example:

EndTimeStamp 11 - december - 2012 15:00:00

StartTimeStamp 8 december 2012 13:00:00

The interval is 70:00:00 but it displays 23 and it's wrong

Any help for me ? Thanks in advance for your help

CELAMBARASAN — Tue, 11 Dec 2012 18:28:31 GMT

To get hour use interval function itself

Interval(runtime, 'hh')

because hour is upto 23 hours only it consider hour for a day.

Anonymous — Tue, 11 Dec 2012 20:43:43 GMT

Thanks very much !!!