Here is a quick example for you.
Add this to a new Qlik Sense app in the script:
LOAD * INLINE [
LOAD * INLINE [
CityFrom, CityTo, Value
Oslo, Stockholm, 8
Stockholm, Copenhagen, 30
Copenhagen, Helsinki, 44
CityFrom AS City
Drop Table Temp_Facts;
Then for your layer settings do:
Dimension is City
Location StartPoint: CityFrom
Location EndPoint: CityTo
With By: Sum(Value)
That gives you this:
And you can play around with the settings afterwards.
Basically you need in your data model something that tells where something originated and where it is going to. Either by a name Qlik Sense can do lookups on or by adding a long / lat value so that you can use that.
Also added the app as an attachment.
Test.qvf 208.0 K
I'm not sure what you mean by "format the lines should have".
The lines are formed between two places so you ned to know where does the line line originate from and where does it need to go to.
You shouldn't have to focus on what format the line has in an ArcGIS solution, instead see if you can in your data where a value originates and where it is going to and have this in your QlikSense data model.
Do you have this kind of info in the datamodel?
That is sufficient to create the line layers.
Not sure if I am misunderstanding?
With format I mean data type, like .excel or .KML
I have generated start, mid and end points for the line, but i still don't get Qlik to display the lines.
I have also created several points for the line (vertices) with coordinates. But it will only plot as points.
Thanks for helping me!
Please see attached app at the original post