topic Re: Ceil functionality in time in QlikView

Ceil functionality in time

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

Hi All,

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

Re: Ceil functionality in time

vishsaggi — Tue, 19 Jun 2018 20:49:44 GMT

May be try this?

Time(Ceil(Frac(Ceil(Sum(Duration),1/1440)), 0.1), 'hh')

Re: Ceil functionality in time

Anonymous — Tue, 19 Jun 2018 21:19:46 GMT

Thank you.

Can you tell how to write ceiling the time in minutes.

Re: Ceil functionality in time

vishsaggi — Tue, 19 Jun 2018 21:39:00 GMT

you mean you want hh:mm ? or only Minutes mm

Re: Ceil functionality in time

Anonymous — Tue, 19 Jun 2018 21:47:21 GMT

for suppose, if I selected 30.06 and 19.20, I want the result to be 50minutes mm ceiling

Re: Ceil functionality in time

vishsaggi — Tue, 19 Jun 2018 23:13:33 GMT

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?

Re: Ceil functionality in time

vishsaggi — Wed, 20 Jun 2018 01:13:14 GMT

You can try this:

TimeDuration:

LOAD * INLINE [

Duration

00:30:06

00:30:31

00:37:06

00:47:37

01:19:20

];

LEFT JOIN(TimeDuration)

LOAD Duration,

//Time(Ceil(Frac(Ceil(Sum(Duration),1/1440)), 0.1), 'hh:ss') AS TimeInt,

Interval(Sum(Duration), 'mm') AS MinSum

Resident TimeDuration

Group By Duration;

In the front end using

= Interval(Sum(Duration), 'mm')

Re: Ceil functionality in time

qlikviewwizard — Wed, 20 Jun 2018 01:22:21 GMT

Hi,

Try this.