topic Timeline analysis in QlikView

Timeline analysis

Thu, 20 Jan 2011 02:55:34 GMT

Hello,

what is the best way to display a timeline in qlikview? For example, I want to display events by the time when they happened. At one time only one thing can happen. Good example of this is timeline of a production development life cycle.

At time t0 : we received requirement

At time t0+ 1hr : developement started

At time t0+ 6hr : product moved to QA

at time t0+12hr : product moved to UAT

at time t0+15hr : product is delivered

You can see attached image for different example as an example done in excel. Now if I try to implement this in bar graphs,I want to display something on Y axis based upon importance of that event.

I know this is possible but what is the best way to do this in qlikview?

Thanks for any reposnse.

Amey

Timeline analysis

Anonymous — Fri, 21 Jan 2011 12:37:57 GMT

Maybe this can help you:

http://community.qlik.com/media/p/111449.aspx

Timeline analysis

Fri, 21 Jan 2011 18:56:44 GMT

Thanks Dennis. But I'm looking for something slightly different. I don't have time duration between events but just want to see what time which even occured. This analysis in the link shows between time durations which activity happened. Any idea?

Timeline analysis

johnw — Sat, 22 Jan 2011 00:53:10 GMT

This probably isn't quite what you're looking for, but it's A timeline example. The first chart is durations, but the second chart is just labeled events on a timeline. I suspect the labeling would just overlap if the event names were very long, though. QlikView isn't very clever about moving text around to make it visible.

Re: Timeline analysis

Tue, 28 Apr 2015 09:57:18 GMT

This is useful John, thanks.

I’d really like to apply a different colour/symbol for each type of event (with a black line between events) – do you know if this would be possible?

I notice that the second example you provide applies a different colour for each type of event so long as only one case is selected.

Thanks again, Michael.

Re: Timeline analysis

Tue, 28 Apr 2015 11:18:16 GMT

Hi.

I’ve added a few lines of data in an attempt to replicate the issues I’m experiencing:

LOAD *
,recno() as IDINLINE [
case,event,RegDate,time
C1,A,17.08.2009 04:00:00,17.08.2009 05:00:00
C1,B,17.08.2009 04:00:00,17.08.2009 05:25:00
C1,C,17.08.2009 04:00:00,17.08.2009 06:00:00
C1,D,17.08.2009 04:00:00,17.08.2009 06:30:00
C1,E,17.08.2009 04:00:00,17.08.2009 09:00:00
C1,F,17.08.2009 04:00:00,17.08.2009 09:47:00
C2,A,17.08.2009 06:00:00,17.08.2009 08:00:00
C2,B,17.08.2009 06:00:00,17.08.2009 09:30:00
C2,C,17.08.2009 06:00:00,17.08.2009 10:00:00
C2,D,17.08.2009 06:00:00,17.08.2009 11:20:00
C2,E,17.08.2009 06:00:00,17.08.2009 11:45:00
C2,F,17.08.2009 06:00:00,17.08.2009 11:59:00
C9,A,17.08.2009 04:00:00,17.08.2009 05:00:00
C9,B,17.08.2009 04:00:00,17.08.2009 05:25:00
C9,A,17.08.2009 04:00:00,17.08.2009 06:00:00
C9,D,17.08.2009 04:00:00,17.08.2009 06:40:00
];

1) Is there a way I can spread the 3 cases evenly along the Y-axis (remove redundant whitespace - see image below)? In my data I have PatientIDs which may be separated by several thousand units.

2) For C9 you will notice event A occurrs twice – so it disappears in the chart, I would really like it to show as follows:

Thanks again, Michael.