Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Geo head map for the world - google chart


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:' &
concataggrmid('$(simpleEncodingMap)', 1+round(61*sum(Sales)/max(TOTAL aggr(DISTINCT sum(Sales), State)),1),1), State), '', fieldIndex('State', State))

Thanks for help.

Matthias

Labels (1)
0 Replies