Discussion Board for collaboration related to Creating Analytics for QlikView.
Is it possible to sum up activities of an agent for an interval of an agent in a bar chart.
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.
What is your table structure ?
A stacked Bar Chart may well suffice.
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.
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.
can u provide the sample data...
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.
That is just the link to this threas.
I have added the QVW.
Many thanks for your help.
Please reduce the data in your QVW as file size is large