topic Re: Count Concurrent/Overlapping Session Timestamps? in QlikView

Count Concurrent/Overlapping Session Timestamps?

b_garside — Wed, 09 Jan 2013 20:33:00 GMT

All,

I have a session log flat file with User sessions. I'm looking for overlapping sessions times by distinct users.

I'm trying to do this at Object or Chart level if possible.

The attached Excel file shows the desired highlighted overlaps. Where my Chart only sees one instance.

My end result would be a chart or column that shows a count for each overlapping session.

User	Document	Month	Day	Year	Session Start	Duration	Session End
Chris	opportunities_projects.qvw	Jan	4	2013	2013-01-04 07:57:44	00:13:29	2013-01-04 08:11:13
Brett	opportunities_projects.qvw	Jan	4	2013	2013-01-04 08:20:18	03:36:52	2013-01-04 11:57:10
Mike	bookings.qvw	Jan	4	2013	2013-01-04 08:32:05	00:30:24	2013-01-04 09:02:29
Christina	opportunities_projects.qvw	Jan	4	2013	2013-01-04 08:33:04	00:30:42	2013-01-04 09:03:46
Kelly	cv_customers_people.qvw	Jan	4	2013	2013-01-04 09:17:33	00:00:40	2013-01-04 09:18:13
Susan	opportunities_projects.qvw	Jan	4	2013	2013-01-04 09:18:16	00:04:40	2013-01-04 09:22:56
Steve	cv_customers_people.qvw	Jan	4	2013	2013-01-04 09:18:16	00:07:32	2013-01-04 09:25:48
Susan	opportunities_projects.qvw	Jan	4	2013	2013-01-04 09:23:13	00:33:37	2013-01-04 09:56:50
Dennis	site_dashboard_md.qvw	Jan	4	2013	2013-01-04 09:44:24	00:12:21	2013-01-04 09:56:45
Susan	opportunities_projects.qvw	Jan	4	2013	2013-01-04 09:57:04	00:30:11	2013-01-04 10:27:15
Susan	site_dashboard_md.qvw	Jan	4	2013	2013-01-04 09:57:19	00:34:31	2013-01-04 10:31:50

Re: Count Concurrent/Overlapping Session Timestamps?

fosuzuki — Fri, 11 Jan 2013 14:02:25 GMT

Check the attached qvw.

Though it has a conceptual problem when the session starts in one day and ends in other.

Re: Count Concurrent/Overlapping Session Timestamps?

b_garside — Fri, 11 Jan 2013 15:36:51 GMT

Great Job Fernando!

I'm ok, with the days not taken into account. The server client session will time out long before that would occur. This meets the analysis perfectly.

Re: Count Concurrent/Overlapping Session Timestamps?

b_garside — Sat, 12 Jan 2013 05:03:50 GMT

If I wanted to change it to larger increments i.e. minutes/hrs vs. 30sec. would it still work?

Re: Count Concurrent/Overlapping Session Timestamps?

fosuzuki — Sun, 13 Jan 2013 14:01:35 GMT

Yes if you change the "sampling" interval it should still work.

Though you must be careful with the time interval not being too distant, as it may not consider a session. For example if you have a session from 00:00:01 to 00:29:59 and your sampling interval is for each 30 minutes, it will not be considered neither in the 00:00:00 and in the next 00:30:00. Hope I made my point clear enough...