Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) 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).
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.
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
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).
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
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,
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