topic Sum Time in QlikView

Sum Time

pgalvezt — Mon, 30 Jan 2012 00:26:17 GMT

Hello!

I would like to know how to sum time. i left a example of What I want to do. I´ve tried with:

Interval(sum(myfield)) but its not working.

Thanks!

Re: Sum Time

rohit214 — Mon, 30 Jan 2012 05:51:21 GMT

Please find the attachment.

Thanks

rohit

Sum Time

Anonymous — Mon, 30 Jan 2012 05:55:04 GMT

Hi there,

if your time field (Tiempo) is in DateTime format you could do the following in your expression.

LEFT(DATE(Tiempo,'hh:mm'),2)*60 + RIGHT(DATE(Tiempo,'hh:mm'),2)

This will convert the hours to minutes then add this result and the minutes together.

ie: 10:35 = 10 hours and 35 minutes.

= 10 hours * 60 minutes = 600 minutes + 35 minutes

= 635 minutes.

Re: Sum Time

Sokkorn — Mon, 30 Jan 2012 06:41:09 GMT

Hi,

Try to add new field as I put in Bold

Rep:
LOAD Cliente as ClienteEJ, 
     Area as AreaEJ, 
     SumOfSum_Diferencia as  SumOfSum_DiferenciaEJ, 
     RE_Cal1 as RE_Cal1EJ, 
     SumOfCant_Persona as  SumOfCant_PersonaEJ, 
     RE_Cal2 as RE_Cal2EJ, 
     RE_Cal3 as RE_Cal3EJ,
     Date(Fecha) as FechaEJ,
     Year(Fecha) as AñoEJ,
     Month(Fecha) as MesEJ,
     Week(Fecha) as SemanaEJ,
     Day(Fecha) as DiaEJ,
     INTERVAL(RE_Cal1+RE_Cal2+RE_Cal3,'hh:mm') as NewField
FROM
(biff, embedded labels, table is Base$);

Regards,

Sokkorn Cheav