Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Map example to show data in a map per city in the netherlands

Hi all,

I'm looking for a good solution to show my data (sales and other measures) on a map, where I'd like for example a bubble-chart on a map, with a bubble per city.

I've checked a lot of examples and the GeoQlik extension as well (from the Qlikmarket), but until now I couldn't make a good-looking / working example.

In my example I'd like to plot the salesamounts per city to the map of the netherlands.

I started with googlemaps (which worked more or less) but the customer I'm creating this for didn't like googlemaps that much (the maptypes).

The customer liked the GeoQlik extension from the market...

I experimented with that (trial) extension...But as far as I can see... This extension does not allow me to plot things per city (only per continent, country and province). Perhaps I didn't have a right look at this extension??

So I have 2 questions

- What extension or thing would you advise for my analysis (plot sales per city in the netherlands only)

- Is my above understanding of GeoQlik correct (meaning that this extension will not meet my requirement)?

I'd like to hear!

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

1) I think ideally, you'd know the exact min/max lat/long for the map image.  Then you'd use the same min/max lat/long for your chart.  Then you'd line up the chart and image borders, and everything should fall in line.  But in practice, you probably won't know the exact coordinates for the map, and probably the best you can do is what you're doing, just make sure the bubbles appear in the right place.  So yes, that's pretty much what I propose. 

Oh, and now that I'm thinking about it, you'll have to be careful in your selection of map.  I believe you need a map with an equirectangular projection (http://en.wikipedia.org/wiki/Equirectangular_projection).  Well, with appropriate north/south stretching (which appears to be about 160% for the Netherlands poking around on Google).  You CAN use other projections, but you'd need to modify where the latitude and longitude plot rather than just plotting them directly on a grid.

2) Is the group just some field in the data model?  If so, you could probably just use a background color expression.  You might even build a Groups table to define the colors:

Groups:
LOAD * INLINE [
Group, R, G, B
Something, 200, 100, 100
...
];

And make the color expression rgb(R,G,B).

View solution in original post

5 Replies
johnw
Champion III
Champion III

A perhaps overly-simplistic answer is to just get a map of the Netherlands and stick it on the screen as a text object.  On top of that, build a transparent scatter chart that displays your data by latitude and longitude.  You just need a source for the latitude and longitude for each city and to line everything up carefully.  Attached is a very rough example.

Not applicable
Author

Hi John,

Thanks for your reply and example .qvw. I really appreciate that.

I don't know what the "beautiful map" is that my customer wants to use, but to get acquinted with this technique, I just picked a random one from the internet (from the netherlands in my case 🙂 ). See attached for the result.

2 questions:

[1] correct mapping of the bubbels on the map

To make sure the bubbles are on the "right" place, I loaded the lat/longs of 4 cities  in my map (one most on east, one most on south, one most on west and one most on north...). and then I tried to make sure that the bubbles are on the right place... Is that indeed the way you propose?

[2] I need to plot  a few(I think 5) groups of bubbles, 1 color per group

My requirement is to plot 4 or 5 groups on the Netherlands, where every group has its own color.

Do I understand it correctly that in this (and perhaps in any other) map-implementation, I need 4/5 bubblecharts (with 1 textbox/image)? Or is it possible to have just 1 chart with 5 series?

Thanks in advance for helping me!

--Roberto

johnw
Champion III
Champion III

1) I think ideally, you'd know the exact min/max lat/long for the map image.  Then you'd use the same min/max lat/long for your chart.  Then you'd line up the chart and image borders, and everything should fall in line.  But in practice, you probably won't know the exact coordinates for the map, and probably the best you can do is what you're doing, just make sure the bubbles appear in the right place.  So yes, that's pretty much what I propose. 

Oh, and now that I'm thinking about it, you'll have to be careful in your selection of map.  I believe you need a map with an equirectangular projection (http://en.wikipedia.org/wiki/Equirectangular_projection).  Well, with appropriate north/south stretching (which appears to be about 160% for the Netherlands poking around on Google).  You CAN use other projections, but you'd need to modify where the latitude and longitude plot rather than just plotting them directly on a grid.

2) Is the group just some field in the data model?  If so, you could probably just use a background color expression.  You might even build a Groups table to define the colors:

Groups:
LOAD * INLINE [
Group, R, G, B
Something, 200, 100, 100
...
];

And make the color expression rgb(R,G,B).

Not applicable
Author

Hi John,

Thanks for your explanation. I think for issue 1) I have enough info.

I like your reference to Equirectangular projections ->definately I would not have realized this!

Concerning issue 2) --> Yes there is a field in the datamodel, so hehe it is easier than I thought so luckily I don't need multiple scattercharts, but I can simply do an if/else statement for the 5 groups.

Again: thanks for your explanation!

#edit

I updated the .qvw a bit, so the issue 2) is implemented: based on the field "waarde" (translated "value") the color is red or blue)

As a reference for everyone

Anonymous
Not applicable
Author

Dear Jhon,

I have posted a query in my page. Can we use multiple latitude and longitude (Territory, Region and Place) in Google map?

This is my recruitment I have Latitude and Longitude for Territory and Place of Mexico. My client needs the scenario like,

  1. On map load or file load he should the see only the Territory information (where he should see 11 dots on map) data source for this is Excel. But sales data of place is from DB I have around 7000+ records in data base
  2. Once the double click the one Territory by Territory 4 the map should zoom in and show all the regions for that territory (each territory has maximum of 9 regions). While showing the region it should all the region values plotted on the map
  3. After this if they select the one region by say region 7 map should zoom in and show all the sales place for that particular region (each region has many sales point)

I have attached the sample screen of excel wth this.

Is this possible in QV? 

Hope you understand this if you have any clarification pls let me know.

Thanks & Regards,

Nandha