Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandermllr
Creator
Creator

Qlikview - timeline and places chart

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

Hamburg01.02.2017 14:0001.02.2017 19:24

12345

Hamburg

Berlin

02.02.2017 04:01

02.02.2017 07:55

98765Paris

Cologne

04.03.2017 07:33

04:03.2017 15:43

98765CologneMunich

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!

11 Replies
Kushal_Chawda

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

alexandermllr
Creator
Creator
Author

Yes i would do that.

But the big problem is linechart.

Kushal_Chawda

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

Kushal_Chawda

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

alexandermllr
Creator
Creator
Author

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.

Train_Chart.PNG

alexandermllr
Creator
Creator
Author

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

I really need some help...