Qlikview - timeline and places chart

[alexandermllr]

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!

[Peter_Cammaert]

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?

[alexandermllr]

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.