Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

GoogleMaps and Qlikview

I have a questions about GoogleMaps and QlikView.  Has anyone recently done anything with GoogleMaps that care share how it is done.  Second and most important is what I would like to do is the county I live in has 170 School Systems and I have the following information:

Location Name: Adams Elementary

Address - 805 Cary Towne Blvd

City - Cary

State - NC

ZipCode - 27511

What I would like to do is to have that information linked to a latitude and longitude degrees.  I would need to render the data based on Address,City, State because I would love to show it at the street level.  The other thing I was wondering is can you use three different pins one for each of the types of schools.  Elementary, Middle, High School. 

Any help on this would be awesome.

David

1 Solution

Accepted Solutions
whiteline
Not applicable

Re: GoogleMaps and Qlikview

Hi.

Getting the lat/long by address is not directly relative to QV. But you can try to use geocoder webservice (google maps or so) directly from load script and store the coordinates. Read the Google Geocoding API online help.

After that, there are plenty of examples (with and without extensions) how to take some benefits from geo data with googlemaps.

2 Replies
whiteline
Not applicable

Re: GoogleMaps and Qlikview

Hi.

Getting the lat/long by address is not directly relative to QV. But you can try to use geocoder webservice (google maps or so) directly from load script and store the coordinates. Read the Google Geocoding API online help.

After that, there are plenty of examples (with and without extensions) how to take some benefits from geo data with googlemaps.

maxgro
Not applicable

Re: GoogleMaps and Qlikview

first question

search for google-maps-address-data in the Community or look at the attachment as a working example for getting coordinates from address

second question

I think you can get different color for each type of school; change the backgroun color of first expression of your google map chart (scatter)depending on school type