Qlik sense Map

[sophiebarnes]

Hi all, 

I'm not sure if this is possible as I see it a little bit complicated to get done.

I have a table with some columns

id	userid	visit_date_time	postcode
12	125	26/09/2021 13:01	BB8 9EA
13	125	26/09/2021 13:15	LS24 6TS
14	125	26/09/2021 13:25	S70 3SB
15	125	26/09/2021 14:02	BP1 5AN

I need to manipulate the data, then the outcome that I'm trying to get to is;

I want to see in the map based on this user where has he been based on the date time and post codes as starting point and time, as the first time being the starting point location and the last time being the end point location.

is this possible,  I have seen a Youtube video https://www.youtube.com/watch?v=CSPCNfnIMp8 but it shows as Departure and  Arrival, 

But how do I manipulate my data to be able to do that

[abhijitnalekar]

Hi @sophiebarnes ,

You have to add one more column of destination postal code. considering the current postal code as the origin.

then you can assign the fields to the line layer on the map accordingly.