Geo head map for the world - google chart

Mon, 22 Sep 2014 09:25:19 GMT

Hi,

I would like to create a head map of the world, but I can only find country specific
examples.

My data set contains the county as the ISO code and the sum (sales) as the
value I would like to show. I have successfully reproduced the Example given in
the QlikView Cookbook, by Rob Wunderlich, but I need something showing the world
as the map. Where "usa" would be world and "state" = Country, I do not need any fancy "zoom" functionality.

='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))

Thanks for help.

Matthias

topic Geo head map for the world - google chart in QlikView

Geo head map for the world - google chart