This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a field 'duration' having different values.
Now I want to calculate the sum of them and show the result in 'hours' using ceil function.
Expected result = 4 hrs
Please help me with this.
Thanks in Advance
You can try this:
LOAD * INLINE [
//Time(Ceil(Frac(Ceil(Sum(Duration),1/1440)), 0.1), 'hh:ss') AS TimeInt,
Interval(Sum(Duration), 'mm') AS MinSum
Group By Duration;
In the front end using
= Interval(Sum(Duration), 'mm')
View solution in original post
May be try this?
Time(Ceil(Frac(Ceil(Sum(Duration),1/1440)), 0.1), 'hh')
Can you tell how to write ceiling the time in minutes.
you mean you want hh:mm ? or only Minutes mm
for suppose, if I selected 30.06 and 19.20, I want the result to be 50minutes mm ceiling
So you do not want Hours to be counted when you select, coz you have a value that has 1 hour 19min 20secs so you do not want to consider 1hour?