topic Re: Sum of Time Measure in QlikView

Sum of Time Measure

Anonymous — Fri, 30 May 2014 08:46:29 GMT

Hello,

I am having #ShiftStartTime/#ShiftEndTime of a Employee say XYZ.

I want to show total no. of hours of XYZ from this time measure. I am using sum(#ShiftEndTime-#ShiftStartTime) but its not working.

Can some body suggest to me what I can do in this case?

Regards,

Balraj

Re: Sum of Time Measure

crusader_ — Fri, 30 May 2014 08:50:37 GMT

Hi,

What exact result gives your expression?

'-' or '0,12312' or smth else.

Try

Interval( sum(#ShiftEndTime-#ShiftStartTime) )

Regards,

Andrei

Re: Sum of Time Measure

jagan — Fri, 30 May 2014 08:55:19 GMT

Hi,

Try like this

Load

Num(Interval(ShiftEndTime - ShiftStartTime, 'h')) AS Hours

FROM DataSource;

Now use this expression

=Sum(Hours)

Regards,

Jagan.

Re: Sum of Time Measure

Anonymous — Fri, 30 May 2014 08:55:28 GMT

Hello Andrei,

Its not working, still its giving 1 with your expression else 0.

Regards,

Balraj

Re: Sum of Time Measure

anbu1984 — Fri, 30 May 2014 09:00:08 GMT

What is the time format in #ShiftEndTime and #ShiftStartTime?

Re: Sum of Time Measure

jonathandienst — Fri, 30 May 2014 09:01:39 GMT

It depends on what you actually have in these two fields (the underlying value, not the displayed value). If they are normal date/time/timestamp fields, then the time portion is a fraction of a day. To get the interval in hours (not just display in hours), use

(#ShiftEndTime-#ShiftStartTime) * 24 (in hours)

(#ShiftEndTime-#ShiftStartTime) * 1440 (in minutes 1440 = 24*60)

To display in hh:mm (the underlying value does not change, just the display format) use:

interval((#ShiftEndTime-#ShiftStartTime) * 24, 'hh:mm')

HTH

Jonathan

Re: Sum of Time Measure

crusader_ — Fri, 30 May 2014 09:06:01 GMT

Can you share a qvw sample?

Andrei

Re: Sum of Time Measure

Anonymous — Fri, 30 May 2014 09:20:05 GMT

Hello Jagan,

Will it work for minutes?

Regards,

Balraj

Re: Sum of Time Measure

Anonymous — Fri, 30 May 2014 09:20:42 GMT

Jonathan,

Time is into 24 hr format, but your expression is not working.

Regards,

Balraj

Re: Sum of Time Measure

jagan — Fri, 30 May 2014 09:37:38 GMT

Hi,

Try like this for minutes

Load

Num(Interval(ShiftEndTime - ShiftStartTime, 'm')) AS Minutes

FROM DataSource;

Now use this expression

=Sum(Minutes)

Regards,

Jagan.