Sum activities in interval of 30 mins

[#1]

Hello All,

Is it possible to sum up activities of an agent for an interval of an agent in a bar chart.

Example

8:00 to 8:30 -  10 Mins break and 20 mins on call

8:30 to 9:00 - 30 mins on call

9:00 to 9:30 - 10 mins break and 20 mins on call.

I need a chart like the above in qlikview.

Many Thanks,

Hasvine

[Anonymous]

What is your table structure ?

A stacked Bar Chart may well suffice.

[#3]

Ya but the problem is that if for example an agent goes on break at 8:27 and returns at 8:47. It shows the 20 minutes in the 8:30 bar but instead I want it to break it like 3 mins for the 8:00 bar and 17 mins in the 8:30 bar.

[Anonymous]

You may also need to use the IntervalMatch() function, have a look at this blog post IntervalMatch by Henric.

But unless you share some sample data I can only guess.

[PradeepReddy]

can u provide the sample data...

[#6]

Hi All,

You may get the sample by clicking on the link below:

Sum activities in interval of 30 mins

I have explain in more detail the issue.

Many thanks,

Hasvine

[Anonymous]

That is just the link to this threas.

[#8]

Hi Bill,

I have added the QVW.

Many thanks for your help.

KR,

Hasvine

[Kushal_Chawda]

Please reduce the data in your QVW as file size is large