Bubbels Google Map not working

[jjordaan]

Hello QlikView friends,

I have created multiple QlikView applications using google maps with Geocoding by Yahoo.
The geocoding was loading while the dashboard was retrieving the from the QVD's.

When creating a new dashboard for a customer I'm retrieving the GeoCode during the reload of the QVD Loader (QVD's are made ​​from a Navision database) the geocoding is based on the combination of city and country code. The latitude and longitude are retrieved from Yahoo.

I'm storing the latitude and longitude information in a separate QVD. This QVD is using a incremental reload when there is a new combination of City and Countrycode entered in Navision.

In the dashboard I make combined key based on City-CountryCode from the table GeoCode to link with the Customer table City-CountryCode.

What I do not manage is to get the bubbles in the right place in the Map.
If I change the folder via a fast change to a straight table, I see that there is no longitude and latitude filled, while these data are present?

Can someone help me with this issue?

I have added a sample dashboard with 2 QVD files.

Thank you

[jjordaan]

If anyone has time and who can help me with this problem then please.

thanks

[jjordaan · Accepted solution]

I solved the problem myself.

The Latitude and Longitude fields from the QVD were interpreted as text. I have placed the # Num () function around the fields so the fields are convert to numeric.