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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
daniel_robu
Contributor II
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)  ?

0 Replies