Qlik Sense: LINESTRINGs in Maps

[morenoju]

Hi guys,

In my data I have LINESTRING locations such as:

LINESTRING(-96.7 32.79196,-96.69975 32.792,-96.6996 32.79202,etc.)

So they're not a straight line, but more like a path.

I use a pretty old version of Qlik Sense, so I wonder if new versions have native maps that allow representing such kind of linestrings? Did any of you have experience with this?

Thanks,

Juan

[Channa]

in the latest version they have Line Start and Endpoints

it will allow to choose 2 fields 

[morenoju]

Thanks Channa, but that sounds like a straight line, and I'm referring to drawing paths with several intermediate points.

[morenoju]

Is this something in the Qlik Sense roadmap for future versions?

Allowing a LINESTRING with several points as the geometry field for a map layer.

[morenoju · Accepted solution]

Qlik Sense June 2019 finally supports this!

[qliklover]

hi, may i know how did u connect several points using one continuous line? currently, i have a map chart that has several points and i want to connect all these points using one continuous line, not just from the start point to end point. i wish to achieve something similar to the picture attached 

thanks!

[morenoju]

Hi @qliklover ,

First create the points when you load your longitude and latitude fields:

GeoMakePoint(location_latitude,location_longitude) as journeyPoint

Then you can load the paths using concatenation like this:

[journey_paths]:
LOAD journeyId,
'[' & concat(journeyPoint,',',pointOrder) & ']' as journeyPath
Resident journey_points
group by journeyId;

The field pointOrder is whatever field you have that can help to figure out what point goes first.

I hope this helps,

Juan