topic Cumulative Time in Pivot Table in QlikView

Cumulative Time in Pivot Table

Mon, 14 Sep 2009 23:41:54 GMT

I have a Pivot Table which displays minutes for every job. I have converted minutes into time through MakeTime function and starting from 6:00 AM. Here is the layout:

JOB Minutes Time

1 45 6:45 AM

2 60 7:00 AM

3 45 6:45 AM

Now I want to display the time by adding the minutes into it. Like this:

JOB Minutes Time

1 45 6:45 AM

2 60 7:45 AM

3 45 8:30 AM

Any suggestions would be appreciated.

Thanks a lot!!!

Cumulative Time in Pivot Table

stephencredmond — Tue, 15 Sep 2009 00:03:55 GMT

Hi,

Use a combination of RangeSum and Above. E.g.


Time( Num(Time(StartTime)) + (RangeSum(Above(Sum(Mins),0,RowNo()))/(60*24)))

Stephen

Cumulative Time in Pivot Table

Tue, 15 Sep 2009 01:26:12 GMT

Thanks Stephen, it works like a charm!!!