Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Help with the SUM of Hours

Hi

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.

1 Solution

Accepted Solutions
gandalfgray
Valued Contributor

Re: Help with the SUM of Hours

In the Chart properties

goto the Number tab,

mark the Expression

and tick the Interval

chartpropnumber.JPG

5 Replies
gandalfgray
Valued Contributor

Re: Help with the SUM of Hours

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

/GG

Not applicable

Re: Help with the SUM of Hours

How I create the number format to interval?

Thanks ..

Re: Help with the SUM of Hours

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
Valued Contributor

Re: Help with the SUM of Hours

In the Chart properties

goto the Number tab,

mark the Expression

and tick the Interval

chartpropnumber.JPG

Not applicable

Re: Help with the SUM of Hours

Thanks it was the format ..

Community Browser