topic Re: Qlikview - timeline and places chart in QlikView

Qlikview - timeline and places chart

alexandermllr — Wed, 24 May 2017 08:38:10 GMT

Hello,

I have a big problem with creating a timeline chart of my data (Trains).

I have this database:

Key	Start_Place	End_Place	Start_Time	End_Time
12345	Munich	Cologne	01.02.2017 05:00	01.02.2017 12:34
12345	Cologne	Hamburg	01.02.2017 14:00	01.02.2017 19:24
12345	Hamburg	Berlin	02.02.2017 04:01	02.02.2017 07:55
98765	Paris	Cologne	04.03.2017 07:33	04:03.2017 15:43
98765	Cologne	Munich	04.03.2017 16:00	04.03.2017 22:05

I want to have a linechart about the trains.

(When the trains is driving from one place to another and how long the train is at one place waiting)

I hope someone can help me!

Thank you!

Re: Qlikview - timeline and places chart

Kushal_Chawda — Wed, 24 May 2017 10:36:56 GMT

How do you know that train wait time at one place?

Re: Qlikview - timeline and places chart

Peter_Cammaert — Wed, 24 May 2017 10:47:01 GMT

Probably by matching the Start_Place to the End_Place of the previous leg and subtracting corresponding Start_Time from End_Time.

Re: Qlikview - timeline and places chart

Peter_Cammaert — Wed, 24 May 2017 10:48:21 GMT

Can you show us an example of the line chart you want to obtain? Including dimensions?

You can do this in Excel with dummy data.

Re: Qlikview - timeline and places chart

alexandermllr — Wed, 24 May 2017 10:49:17 GMT

Yes i would do that.

But the big problem is linechart.

Re: Qlikview - timeline and places chart

Kushal_Chawda — Wed, 24 May 2017 10:53:53 GMT

So I think you need to have End_Place as dimension, where train halts. Right?

Re: Qlikview - timeline and places chart

Peter_Cammaert — Wed, 24 May 2017 10:56:58 GMT

And avg(Waiting_Time) as an expression? Sounds good. But a line chart?

Re: Qlikview - timeline and places chart

Kushal_Chawda — Wed, 24 May 2017 11:01:46 GMT

Yes, this seems to be good as per the data and requirement.

Re: Qlikview - timeline and places chart

alexandermllr — Wed, 24 May 2017 11:15:44 GMT

Yes, something like this.

But it would be better if we change the Time/Place dimension.

So if the train is waiting there is a straight line and every place is only one time there.

Re: Qlikview - timeline and places chart

alexandermllr — Mon, 29 May 2017 11:34:31 GMT

Is there any way I can get a Chart like this?

I really need some help...

Re: Qlikview - timeline and places chart

Peter_Cammaert — Mon, 29 May 2017 11:49:33 GMT

From your last explanation I understand that you want to ignore the delays when the train is not running (at the station). That means that either you select the arrival or the departure time as a single point in your line chart, or that you want to move all following laps forward in time. Which will it be?

I still wonder about what you really want to analyse in QlikView? Top 20 delays? Waiting/Running time ratio's? Or do you just want to show a succession of many (hundreds, thousands?) similar line segments?

Re: Qlikview - timeline and places chart

alexandermllr — Mon, 29 May 2017 12:08:58 GMT

If it is possible I don't want to ignore the delay at the Station.

I want to select a day and then see all trains over 24 hours (every quarter of an hour), to get a Overview about the trains and be able to plan the trains better.