Geographical heat map using Google chart API - '&chd=s:' parameter wrong display

daniel_robu — Sat, 09 Jun 2012 19:58:32 GMT

From cookbook of Rob Wunderlich I made some modification on the file GoogleChartMap to adapt on the Romanian map but I got stuck on the last parameter

& '&chd=s:' & concat( aggr( mid('$(simpleEncodingMap)', 1+round(61*sum(Sales)/max(TOTAL aggr(DISTINCT sum(Sales), State)),1),1), State), '',

fieldIndex('State', State))

I replace State with ISO2, the map is showing but when I select de sume value of a County is showing the dates for other county.

e.g. :I press on RO-BC and the map select RO-HD

Somenone could help or explain more clearly the whole parameter (aggr( mid('$(simpleEncodingMap)', 1+round(61*sum(Sales)/max(TOTAL

aggr(DISTINCT sum(Sales) ?

topic Geographical heat map using Google chart API - '&chd=s:' parameter wrong display in QlikView

Geographical heat map using Google chart API - '&chd=s:' parameter wrong display