topic Re: time calculation in QlikView

time calculation

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

Hi,

I want to display the sum of duration in ceil as default. (when no value is selected in Number Field).

(here as the sum of duration in minutes is more than 60min, so I want the default result to be in hours).

If a value(s) is selected in Number Field, then if sum of duration in minutes < 60, then the result should be in ceil minutes else in ceil hours.

Can this be done in a textbox with expressions?

Please help me with this.

Thanks in Advance.

Re: time calculation

MarcoWedel — Wed, 20 Jun 2018 20:23:18 GMT

Hi,

one solution could be:

Ceil(Sum(Duration)*If(Sum(Duration)<1/24,1440,24))

hope this helps

regards

Marco

Re: time calculation

tmackay2015 — Wed, 20 Jun 2018 20:53:27 GMT

try this

interval( Sum(Duration),

IF(sum(Duration)<(1/24), 'mm', 'hh')

)

this should format the value to display minutes/ or hours but not alter underlying numbers.

this is useful for ordering by value.

-Tom