Hi community,
I have the google maps object embedded into my QV sheet and I would like to have the cluster and/or the marker in a different colour depending on the value of the field “Organization” (see attached “GoogleMapsObject”). For instance, I would like to have all the clusters and/or the markers related to the “Australia Post” value in green, the Clusters/Markers related to “DHL” value in blue, and so on.
What I have done so far is to allocate a “Marker flag” for each value of the Organization field (see attached “MarkerFlag”) and create the script below in the field “Custom Marker URL” of the GoogleMaps Properties (I also tried in the "Measurement" field):
=If(Match(Marker_Flag,99),
'http://maps.google.com/mapfiles/ms/icons/green-dot.png',
If(Match(Marker_Flag,100),
'http://maps.google.com/mapfiles/ms/icons/red-dot.png',
'http://maps.google.com/mapfiles/ms/icons/blue-dot.png'
))
However, neither the cluster nor the marker change on the map even if I select “Australia Post” in the filter (on the left hand panel).
Any idea of what I have done wrong or if there is another way to approach this?
