topic Re: Map view with trace in App Development

Map view with trace

l26b — Mon, 25 Nov 2024 13:47:28 GMT

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

Re: Map view with trace

SterreKapteijns — Tue, 26 Nov 2024 10:00:36 GMT

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.

Re: Map view with trace

l26b — Tue, 26 Nov 2024 12:51:08 GMT

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

Re: Map view with trace

SterreKapteijns — Tue, 26 Nov 2024 12:57:45 GMT

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