Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using GoogleMaps - help for a beginner

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

2 Replies
Not applicable
Author

Attached is a re-engineered version of Rob's document....

Not applicable
Author

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...