Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Sum activities in interval of 30 mins

What is your table structure ?

A stacked Bar Chart may well suffice.

Not applicable

Re: Sum activities in interval of 30 mins

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.

Re: Sum activities in interval of 30 mins

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
Valued Contributor II

Re: Sum activities in interval of 30 mins

can u provide the sample data...

Not applicable

Re: Sum activities in interval of 30 mins

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

Re: Sum activities in interval of 30 mins

That is just the link to this threas.

Not applicable

Re: Sum activities in interval of 30 mins

Hi Bill,

I have added the QVW.

Many thanks for your help.

KR,

Hasvine

Re: Sum activities in interval of 30 mins

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

Community Browser