topic Re: Implementing Google Map in QlikView

Implementing Google Map

Thu, 23 Aug 2012 09:27:57 GMT

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

Re: Implementing Google Map

Anonymous — Thu, 23 Aug 2012 13:33:36 GMT

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.

Re: Implementing Google Map

Thu, 23 Aug 2012 13:49:56 GMT

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

Re: Implementing Google Map

Anonymous — Thu, 23 Aug 2012 14:19:28 GMT

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.

Re: Implementing Google Map

Mon, 27 Aug 2012 06:12:27 GMT

You are to kind, thank you very much.

Re: Implementing Google Map

Mon, 27 Aug 2012 06:47:40 GMT

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

Re: Implementing Google Map

Anonymous — Mon, 27 Aug 2012 08:36:47 GMT

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.