topic Re: Map Visualisations - Multiple layers, Origin + Destination country, Logistics in App Development

Map Visualisations - Multiple layers, Origin + Destination country, Logistics

Fri, 15 Jan 2016 08:19:41 GMT

Hi Everyone,

I am working on a map visualisation.

I have one table with assignment data. Each assignment has a Origin country and a Destination Country(each assignment is a international transport).

I have managed to make a map showing all assignments / origin country and the same for Destination country.

But now I need a map showing all transports in and out of each country. I have not found a way to combine the data.

Any Ideas?

Data model is in the picture. I have Geo points for origin and destination in 2 different tables.

Thanks in advance for any assistance.

Regards

Oskar

Re: Map Visualisations - Multiple layers, Origin + Destination country, Logistics

vinay_hg — Fri, 15 Jan 2016 12:05:25 GMT

as of now i guess map will take only one measure, either u cab show origin details or departure details at a time. or side by side u can create 2 maps one with origin & one with departure.. anyway i had not worked on qliksense map yet.

Re: Map Visualisations - Multiple layers, Origin + Destination country, Logistics

reddy-s — Fri, 15 Jan 2016 20:59:00 GMT

Hi Oskar,

I am assuming that you would like to show the connections between two locations. For this you will have to make use of an extension and cannot be down with the existing map object. I would suggest you to have a look at the extensions in Qlik Branch.

You can even build one using D3.js and use the libraries in https://flowingdata.com/2011/05/11/how-to-map-connections-with-great-circles/ this url to draw connections between cities.

Let me know if you need help building this extension.

Thanks and Regards,

Sangram Reddy.

Re: Map Visualisations - Multiple layers, Origin + Destination country, Logistics

Mon, 18 Jan 2016 08:00:42 GMT

Hi Sangram,

At this stage I don't need lines between the countries. Only need to have Import+export shipments shown / country.

But I might build an app showing the lines between the countries in the future.

Regards

Oskar

Re: Map Visualisations - Multiple layers, Origin + Destination country, Logistics

reddy-s — Mon, 18 Jan 2016 09:00:34 GMT

Hi Oskar,

In that case make use of GeoMakePoint(Lat,Long) for both the Import and Export shipment locations.

This should solve your issue.

Thanks and Regards,

Sangram Reddy.

Re: Map Visualisations - Multiple layers, Origin + Destination country, Logistics

Mon, 18 Jan 2016 09:03:41 GMT

Hi Sangram,

I have tried, but it seams I can only choose to show either import or export stats on one map. Not both at the same time?

Regards

Oskar

Re: Map Visualisations - Multiple layers, Origin + Destination country, Logistics

Mon, 18 Jan 2016 09:44:56 GMT

Only one set of Geo points in a point layer..

I would like to have the geo points for both the import and export stats in the same layer..

As it is now I have to make 2 maps one for import stats and one for export stats and show then beside each other.

Re: Map Visualisations - Multiple layers, Origin + Destination country, Logistics

reddy-s — Mon, 18 Jan 2016 10:27:44 GMT

Hi Oskar,

That's true, you cannot yet add multiple layers. I would suggest you to go with an extension for this purpose.

Thanks and Regards,

Sangram Reddy.

Re: Map Visualisations - Multiple layers, Origin + Destination country, Logistics

reddy-s — Mon, 18 Jan 2016 13:43:08 GMT

Hi Oskar,

I would do it this way.

Create a table with all the points info and an extra flag filed which says if its an import or an export location. Then once plotted I would colour it based on this flag.

If you face issues just attach a sample qvf and I will help you solve it.

Thanks and Regards,

Sangram Reddy.