Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

b_garside
Valued Contributor

Count Concurrent/Overlapping Session Timestamps?

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.

UserDocumentMonthDayYearSession StartDurationSession End
Chrisopportunities_projects.qvwJan420132013-01-04 07:57:4400:13:292013-01-04 08:11:13
Brettopportunities_projects.qvwJan420132013-01-04 08:20:1803:36:522013-01-04 11:57:10
Mikebookings.qvwJan420132013-01-04 08:32:0500:30:242013-01-04 09:02:29
Christinaopportunities_projects.qvwJan420132013-01-04 08:33:0400:30:422013-01-04 09:03:46
Kellycv_customers_people.qvwJan420132013-01-04 09:17:3300:00:402013-01-04 09:18:13
Susanopportunities_projects.qvwJan420132013-01-04 09:18:1600:04:402013-01-04 09:22:56
Stevecv_customers_people.qvwJan420132013-01-04 09:18:1600:07:322013-01-04 09:25:48
Susanopportunities_projects.qvwJan420132013-01-04 09:23:1300:33:372013-01-04 09:56:50
Dennissite_dashboard_md.qvwJan420132013-01-04 09:44:2400:12:212013-01-04 09:56:45
Susanopportunities_projects.qvwJan420132013-01-04 09:57:0400:30:112013-01-04 10:27:15
Susansite_dashboard_md.qvwJan420132013-01-04 09:57:1900:34:312013-01-04 10:31:50

Chart For Log.png

1 Solution

Accepted Solutions
fosuzuki
Valued Contributor II

Re: Count Concurrent/Overlapping Session Timestamps?

Check the attached qvw.

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

4 Replies
fosuzuki
Valued Contributor II

Re: Count Concurrent/Overlapping Session Timestamps?

Check the attached qvw.

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

b_garside
Valued Contributor

Re: Count Concurrent/Overlapping Session Timestamps?

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.

b_garside
Valued Contributor

Re: Count Concurrent/Overlapping Session Timestamps?

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

fosuzuki
Valued Contributor II

Re: Count Concurrent/Overlapping Session Timestamps?

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...

Community Browser