Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum activities in interval of 30 mins

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.

Capture2.PNG

I need a chart like the above in qlikview.

Many Thanks,

Hasvine

8 Replies
Anonymous
Not applicable
Author

What is your table structure ?

A stacked Bar Chart may well suffice.

Not applicable
Author

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
Not applicable
Author

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
Specialist II
Specialist II

can u provide the sample data...

Not applicable
Author

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
Not applicable
Author

That is just the link to this threas.

Not applicable
Author

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