topic time in QlikView

time

Fri, 16 Sep 2011 17:30:59 GMT

how to count time? I've a turntable with the expression sum (time)

value 01:00 + 04:00 results in 05:00 = oke

value 10:00 + 20:00 results in 06:00 = not oke must be 30:00

what parameters do i have to set to get this right

in excel i use [hh]:mm but that does not work in QV

regardz Ed

swuehl — Fri, 16 Sep 2011 17:34:14 GMT

Hi Ed,

please look into interval() function, which will format your resulting time period as wanted.

(Use HELP F1 for details and take a look into format codes as well).

Regards,

Stefan

Fri, 16 Sep 2011 18:11:50 GMT

Hi,

Your expression is correct.

I hope currently the number has just "mm:ss". Try to add "h". If your format is like "h:mm:ss",

then you can change in the number format for the expression.

Hence you get the desired result.

Regards,

Srini.

Sokkorn — Sat, 17 Sep 2011 03:06:44 GMT

Hi Ed,

Try this function:

INTERVAL(T1+T2+T3,'hh:mm') ==> Where T1,T2,T3 is your time field.
Or 
INTERVAL('01:00'+'02:00','hh:mm')

Check more in the attached file.

Let me know if this one help you.

Regards,

Sokkorn

Sat, 17 Sep 2011 15:10:43 GMT

He thanx

change te format from time to interval and it works

Great and thanx everybody.