topic Re: Output total hours in QlikView

Output total hours

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

num(Interval(Timestamp(Timestamp#(Closed, 'DD/MM/YYYY hh:mm:ss')) - Timestamp(Timestamp#(Created, 'DD/MM/YYYY hh:mm:ss')), 'hh'), '#.##') as [Time Open (hours)],

I'm looking to pull total Open Hours.

Anyone see my error? I'm getting a blank output at the moment.

Re: Output total hours

fvelascog72 — Mon, 29 Jan 2018 12:14:52 GMT

Hi,

For me is working fine. Maybe Date formats.

Can you share an example of your data?

Saludos.

Re: Output total hours

Clever_Anjos — Mon, 29 Jan 2018 12:19:27 GMT

Which format are Closed and Created?

Interval(Closed -Created) should be enough

Re: Output total hours

shiveshsingh — Mon, 29 Jan 2018 12:23:29 GMT

Try this

=num(interval(num(Timestamp(Closed,'DD/MM/YYYY hh:mm:ss'))- num(Timestamp(Created, 'DD/MM/YYYY hh:mm:ss')),'hh'), '#.##')

Re: Output total hours

sunny_talwar — Mon, 29 Jan 2018 13:00:33 GMT

Have you made sure to check if Closed and Created date were not getting correctly read as timestamps by QlikView? If they were, you could have just used

Num#(Interval(Closed - Created, 'hh'), '##') as [Time Open (hours)],

Also, do you need to convert hour into a number? if not, then Num#() function is not really needed.... but you can use it..

Finally, if you do need TimeStamp#(), then try like below.

Num#(Interval(Timestamp#(Closed, 'DD/MM/YYYY hh:mm:ss') - Timestamp#(Created, 'DD/MM/YYYY hh:mm:ss'), 'hh'), '##') as [Time Open (hours)],