Blog Archives

QlikView & Google Maps – Logistics

Another cool data visualisation with QlikView and Google Maps. See all the places your cars went in one glance or play GPS history. Happy Qliking! Advertisements

Tagged with: , ,
Posted in Google Maps

QlikView & Google Maps – How to automatically spell-check customer addresses and get location information

Using Google Geocoding Service we can convert addresses into geographic coordinates. Before converting, the service is performing a spell-check on the address and return the result. Let’s say we have a list of customers: Addresses: LOAD *, RowNo() as ID

Tagged with: , ,
Posted in Google Maps

QlikView & Google Maps – Real Estate Demo

Using Google Maps in Real-Estate business help us to add context information to the portfolio. We can automatically calculate information like the distance from the nearest kindergarden or metro station, depending on customer requirements. Captions available in English and Romanian.

Tagged with: , ,
Posted in Google Maps

Google Maps API changed from v2 to v3

If your Google Maps objects doesn’t work anymore in QlikView, you have to change the API call to match the new V3 syntax: Old call: =’http://maps.google.com/staticmap?center=‘ &var_mid_lat&’,’&var_mid_long&’ &zoom=$(var_zoom)’&’ & maptype=’&var_maptype&’ &size=400×400’&’ &key=’&gmap_key &’.jpg’ New call: =’http://maps.googleapis.com/maps/api/staticmap?center=‘ &var_mid_lat&’,’&var_mid_long&’ &zoom=$(var_zoom)’&’ &maptype=’&var_maptype&’ &size=400×400’&’

Tagged with: , ,
Posted in Google Maps