Discussion Board for collaboration on QlikView Layout & Visualizations.
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
Go to Solution.
In the Chart properties
goto the Number tab,
mark the Expression
and tick the Interval
I'm guessing, but what if you set the Number format of the expression to "interval"?
How I create the number format to interval?
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'))
Thanks it was the format ..