Map view with trace

[l26b]

Hi, 

I have multiple cars doing multiple journeys and stops, data looks like this: 

CarID

LocationName

PreviousLocation(or LatLong)

Location(or LatLong)

PreviousDatetime

CurrentDatetime
Status(can be In Movement, Stationary, Moving)

this Car travels from point to point during a day and I want to show the journey from A to B but with all stops along the way - so during a day this car has multiple lines of data entry like:

Car ID        LocationName PrevLatLong.   CurrentLatLong.     PrevEventDt.          CurrentEventDT.    Status

1                  New York.      -****,*****        -******,******         01/01/2000  00:00  01/01/2000 00:05 Stationay

1                Boston             -****,*****        -******,******     01/01/2000  00:05  01/01/2000 00:25      Moving
1              Los Angeles   -****,*****        -******,******     01/01/2000  00:25  01/01/2000 00:55      Moving
1             Texas.           -****,*****        -******,******     01/01/2000  00:55  01/01/2000 01:30      Moving
1             Miami.           -****,*****        -******,******     01/01/2000  01:30  01/01/2000 01:50      Moving
1             Chicago          -****,*****        -******,******     01/01/2000  01:50  01/01/2000 03:50      Moving
1             Seattle          -****,*****        -******,******     01/01/2000  03:50  01/01/2000 04:50    Stationary -   End of journey

I want to have a trace with all points - stops for this car for this day or many days - in the end will be limited to have only a couple of days of journey

thank you

[SterreKapteijns]

Do you want to create a map with these locations? If so, you could just use the PrevLatLong. and CurrentLatLong. - fields to create a line layer in a map. 

[l26b]

in the end, it will need to be a trace, for example 10 points connected between them, so a line within each point 

[SterreKapteijns]

Alright, have you tried creating a map chart with a line layer with PrevLatLong. and CurrentLatLong. - fields? That would do it, I guess. 

Line layers | Qlik Sense on Windows Help