topic Re: Help with the SUM of Hours in QlikView

Help with the SUM of Hours

Tue, 24 Jul 2012 13:09:32 GMT

I have a situation with the SUM of Hours,

For example I SUM this Hours

2:00hr + 2:00hr + 2:00hr + 1:57hr and the result with this expression I’m using are 7.95hr and not the real result that is 7.57hr.

This is the expression I’m using:

Sum(Interval((interval#(HoursFac, 'hhhh:mm' )*24),'hhhh:mm'))

I will appreciate your help

Thanks.

gandalfgray — Tue, 24 Jul 2012 13:17:02 GMT

I'm guessing, but what if you set the Number format of the expression to "interval"?

/GG

Tue, 24 Jul 2012 13:20:42 GMT

How I create the number format to interval?

Thanks ..

MayilVahanan — Tue, 24 Jul 2012 13:29:48 GMT

Hi,

Can you say the format of your HoursFac?? data itself having hr. i.e. 2.00hr? Can you post a sample?

Sum(Interval((interval#(HoursFac, 'hh:mm' )*24),'hh:mm'))

gandalfgray — Tue, 24 Jul 2012 13:30:24 GMT

In the Chart properties

goto the Number tab,

mark the Expression

and tick the Interval

Tue, 24 Jul 2012 14:08:22 GMT

Thanks it was the format ..