Using GoogleMaps - help for a beginner

Thu, 07 Apr 2011 16:56:29 GMT

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

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

Using GoogleMaps - help for a beginner

Thu, 07 Apr 2011 17:03:45 GMT

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

Using GoogleMaps - help for a beginner

Thu, 07 Apr 2011 17:49:53 GMT

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

topic Using GoogleMaps - help for a beginner in QlikView

Using GoogleMaps - help for a beginner

Using GoogleMaps - help for a beginner

Using GoogleMaps - help for a beginner