topic Activity timeline help in QlikView

Activity timeline help

Tue, 28 Apr 2015 12:08:21 GMT

Hi.

I’d like to build a timeline showing hospital activity. The timeline should return one row per patient.

My dataset includes PatientID, EventType, DayNumber (DayNumber being the number of the day on which the activity occurred).

One patient may have many events. One patient may have the same event repeated on several occasions and in any order.

The attached is based on an example from John Wetherspoon, I’d like some help with the following:

1) I'd like to show a different colour/symbol for each EventType (this seems to work if there is just one PatientID selected).

2) I'd like PatientIDs to be distributed evenly along the Y axis (this is a real problem when PatientIDs are separated by several thousand units). Scroll bars would be fine.

3) I'd like to display activity where a PatientID is associated several times with the same EventType – currently the graph returns nothing in this instance (eg Event type F for PatientID 1010).

Many thanks in advance, Michael.

Re: Activity timeline help

Anonymous — Tue, 28 Apr 2015 13:21:42 GMT

See if the attached helps, at least in some way. I used line chart instead of the scatter.

1.Color expression:
color(match("Event Type",'A','B','C','D','E','F'))

Also checked persistent colors.

2. Added "Order" field for even distribution.

3. I don't get ths one

Regards,

Re: Activity timeline help

Tue, 28 Apr 2015 14:02:50 GMT

Thanks very much for taking the time to look at this Michael, I really appreciate it.

1) This is good, but can we make the line black? The legend would also need to represent EventType rather than PatientD.

2) I think the problem persists as there are hundreds of thousands of PatientIDs (and therefore by extension Order). If a user selects 2 PatientIDs where the Order value is separated by 10,000 units we still get a lot of white space.

3) Nice one, you fixed this!

Thanks again, Michael.

Re: Activity timeline help

ThornOfCrowns — Tue, 28 Apr 2015 14:17:59 GMT

Hi, Michael.

I had a very similar request for Secondary care info, i.e how many A&E / In Patient / Out Patient attendances for a GP Practice list. It is meant to focus on one patient and has lots of entries for each type for each patient, over time, with the associated costs.

I kludged it by doing something similar to the attached - msolomov has done it more elegantly, of course.

Re: Activity timeline help

Anonymous — Tue, 28 Apr 2015 14:54:38 GMT

I've tried some changes, but not much I can do. Also experimented with a scatter.

If you improve it further - share please

Re: Activity timeline help

joe_warbington — Wed, 07 Oct 2015 16:22:30 GMT

I'm a little late this thread, but perhaps this would be of interest. I just learned of this Timeline extension available on Qlik Branch that might be home run for this type of analysis in healthcare. It's for Qlik Sense, so you can simply move your QVW over and adapt the data to use this extension: http://branch.qlik.com/projects/showthread.php?643-Qlik-Sense-interactve-Timeline

What are your thoughts?

You can download the extension and an example Qlik Sense app to try it out.

Re: Activity timeline help

daveatkins — Tue, 29 Mar 2016 17:53:50 GMT

I realize this is an old thread, but I have a similar issue and am hoping someone has more ideas...

The objective is to display a timeline of events to give a visual indication of what's going on. Here's what I was able to create:

I did this by creating a Line Chart with EventTime as the dimension, and an expression as =Dual(Left(EventDesc,40),EventTime). Values on Data points, display symbol circles. The x-axis has a range with static min = =ArrivalDateTime-.01 and static max =now()

The graph above is not bad, but you can imagine that when time is compressed, the labels overwrite. It would work better if there were a way to have vertical lines and horizontal, stacked text like the movie above.