Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

daniel_robu
New Contributor II

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

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)  ?

Community Browser