Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Am very interested in including GoogleMaps within my QV documents...
At this point in time, have found an example in RobW's cookbook...
http://robwunderlich.com/downloads/
and some additional info here:
http://code.google.com/apis/chart/docs/gallery/new_map_charts.html
Looking at the example (which returns USA), how do I specify which map to retrieve (ie other than USA)?
In the following code, I can see only 1 referance to "USA", and by changing the values to say "uk" or "gb", i do not see the respective map?
-------------------------------------------------------------------------------------------------
='http://chart.apis.google.com/chart?&cht=t'
& '&chs=' & '440x220' /* CHart size */
& '&chtm=' & 'usa' /* Region */
& '&chco=' & 'f5f5f5' /* Color for no value */
& ',' & 'edf0d4,6c9642,13390a' /* Color gradient */
& '&chld=' & concat(DISTINCT State, '', fieldIndex('State', State))
& '&chd=s:' & concat( aggr( mid('$(simpleEncodingMap)', 1+round(61*sum(Sales)/max(TOTAL aggr(DISTINCT sum(Sales), State)),1),1), State), '', fieldIndex('State', State))
-------------------------------------------------------------------------------------------------
At this point in time, I haven't modified the data to reflect a different set of states dependant on the revised country
What is the naming convention for countries, regions (ie countries = ISO naming convention?) - how about cities and counties?
Any tips, greatly appreciated!
Kind regards,
Rich
Attached is a re-engineered version of Rob's document....
This example really helped me:
http://community.qlik.com/media/p/87334.aspx
Also just in case you didn't know there is a limit on how many maps you can generate a day (either 1000 or 2500, something like that) so if you end up getting like a big red X with a weird map looking picture below it, that's why. It took me an hour to figure out what was going on...