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 creatinga new dashboardfor acustomer I'm retrieving the GeoCode duringthe reloadoftheQVDLoader(QVD's aremadefrom aNavisiondatabase) thegeocodingisbased on thecombination ofcityandcountry code. The latitude and longitude are retrieved fromYahoo.
I'm storing thelatitude and longitudeinformationin aseparateQVD. 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, whilethese dataare present?