Am quite new to Google Maps, but more than happy to share what I found out so far....
nb this technique was derived by reviewing Rob Wunderlich's cookbook...
There appears to be a limited amount of background maps available, ie "usa" (which breaks down the various states, "europe" (at country level only?), please see the attached link for a listing of the various maps available
This technique doesn't use longitude and latitude co-ordinates, just needs to have an associated ISO country code to appear on the map - have a look at my "inline" load.
What I am unsure about, is whether by using this technique, countries can further be broken down into the various regions, ie GB-LDN as implied by the google documentation?
Hope this helps, and hopefully someone can advise us whether the use of "GB-LDN" in the data load, will populate cities on the map??
One important thing that I read, but forgot to include in the above, is that the encoding used to interrogate the google system, only allows up to a maximum of 61-63 points (my memory fails, but its in the early 60's) on the map. Should you require additional points /country to be displayed, then perhaps a different approach is required..
Hi RichSheppard, try with this:
& '&chs=' & '440x220' /* CHart size */
& '&chco=' & 'B3BCC0|5781AE|FF0000|FFC726|885E80|518274' /* Color for no value */
& ',' & 'A59D95,1E9D8B,003946' /* Color gradient */
& '&chld=' & concat(DISTINCT region_codes, '|', fieldIndex('region_code', region_codes))
Thanks for your reply, certainly this approach does allow the map to display the various cities as requested!
What changes did you make to the code?
From what I can see, the "fieldIndex" needs to return 'region_code' and not 'region_codes' - what is the reasoning behind this (ie is this a google requirement)?
also the previous "chtm=europe" has been changed to "cht=map"
How do I adapt the script so that when displaying the various cities either you can control how much of the map is visible?
ie in the attached example, when Lisbon, London and Paris are selected/returned in the map, only Lisbon and London are visible (and Paris, is displayed outside of the visible area)?
Once again, many thanks
with updated attachment factoring in cities into the map...
and look for: cht=map:fixed=-60,0,80,-35
It show an example of use to adapt de zoom based in latitude and longitude.
Other changed i made was use | as symbol to concatenate region_codes.
Hope all this can help you.
I have the same question as Rich. Therefore, instead of opening a new thread, I am jumping into his thread.
I am still a bit confused about the key: is it actually needed to get a key, or the dummy one (gmap_key = 'xx') is OK?
And if it's needed, what is the URL to insert, knowing that Qlikview is not a web page?
By the way, I am a self-learner based on the Personal Edition, therefore I am not abe to open the attachments above: please accept my apologies if the answer is inside the files
Hi Jean Jacques,
thanks a lot for encouraging me.
The static map would be a good start... but in the long run I would like to make a dynamic map...
So now, some doubts:
1) I remember that Qlikview9 had an example in the start page, where you could copy-paste the object with chart and map... But now in Qlikview10 I don't see it! Where can I find it?
2) is there a detailed guide for this? I have found here in the community a document called "whitepaper_how_qliktech_uses_qlikview_google_maps.pdf", but it does not explain very much about how to make the chart (for example what to do in the step that is asking for X,Y,Z)
3) I have QV10 Personal Edition: is this a problem? I see that people are exchanging files, but I cannot open them. Is there a workaround solution? (e.g.using a QV installation in a virtual machine, that you don't care about, that you use only to watch other files)
4) Here attached you find a simple data source and the application that is using it. Are you going to be able to open it?? Is it because you have a licensed version?
Anyway, all I would like to do, as an exercise, is to see this data on a google map. Once I will be able to finish this exerise, and play with it, I will be able to do it also for one of my customers, who asked me to do it.
Thanks for the support!