Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

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

Highlighted

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

Highlighted

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.

Highlighted
Creator
Creator

Yes i would do that.

But the big problem is linechart.

Highlighted
MVP
MVP

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

Highlighted

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

Highlighted
MVP
MVP

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

Highlighted
Creator
Creator

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

Highlighted
Creator
Creator

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

I really need some help...