Implementing Google Map

[#1]

Hello,

atached you will find my try for implementing Google Maps.

I followed as far i could the Guide on this forums. But here are my problems:

1. Seems that for no address at all there was a calculated Position for Google

2. My Chart is broken, all dots are on the left only

3. I acnt zoom in and out on the Google Map i implemented

Can somebody help me to fix the issues?

Thank you in advance

kristian

[Anonymous]

Hi Kristian,

Clean up your data and make sure you pass the address and postal code/city correctly to the Google API.

Also check: https://developers.google.com/maps/documentation/geocoding/ and take a look at the many Google Maps samples around on the community.

I've edited your qvw to make it a working example (raw). Hope it helps you to get going.

Regards.

[#3]

Thank you very much for your help. Just another question if i may: How can i see "all" addresses on the map itself? Ive read something about "Scatter Chart" but i dont get it to show me the points.

Thank you again

[Anonymous · Accepted solution]

Hi,

Yes, you can use a Scatter Chart to plot all locations. And let size and color of bubbles depend on expression values. So if you add more fields with data you want to see you can try it out. Take a look at the Tabs Axes and Color and the background color of the longitude expression.

Regards.

[#5]

You are to kind, thank you very much.

[#6]

Ok... here is my last question: Attached you will find my excel file that i work with.

unfortunately the program i export the infos from, puts the "address" field in 2 Lines. When i do "WRap Text" in Excel in QV its still in 2 lines and so the google api cant "read" the address (my first exampel, the address was/is in 2 lines).

Is there a possibility to tell QV: Import the Data but in 1 Line? Or do you have maybe another Idea how i could achieve that?

Thank you

[Anonymous]

Hi, you can use the function subfield and chr(10) as the identifier for the carriage returns.

Table_Test:

LOAD PP,

     [ADRESA (default export)],

     [ADRESA (with deactivatet WRAP but still in 2 lines)],

     subfield([ADRESA (default export)], chr(10), 1) as Clean_Adresa,

     subfield([ADRESA (default export)], chr(10), 2) as Clean_City

FROM TEST_vampiros.xlsx (ooxml, embedded labels, table is TEST);

Then you have two clean fields which you can use. Regards Sander.