topic Re: Latitide and Longitude problem in QlikView

Latitide and Longitude problem

Mon, 09 Mar 2015 08:08:09 GMT

Hi ,

i have to show the google map extension in the chart with lat and long.

Everything is done right according to script, unfortunaltey could not able to get the Google image inside the chart.

Suggestion requierd,

i am attaching the sample app and source file.

Re: Latitide and Longitude problem

jpenuliar — Mon, 09 Mar 2015 09:14:27 GMT

use the attached dynamic image script

Re: Latitide and Longitude problem

Mon, 09 Mar 2015 09:18:54 GMT

Thanks Jonathan,

I have used but still i could not

Re: Latitide and Longitude problem

jpenuliar — Mon, 09 Mar 2015 09:34:12 GMT

But it did show the map in the chart, right?

Are you using the Google API guide ver3?

Re: Latitide and Longitude problem

Mon, 09 Mar 2015 09:36:28 GMT

Yes i am using the same.

unfotrtunately i could not show it.

Can you share the sample app?

Re: Latitide and Longitude problem

jpenuliar — Mon, 09 Mar 2015 09:41:30 GMT

I've attached a sample map with a bit of slider and street-view add-on.

Geocoding from Google works on this one.

Re: Latitide and Longitude problem

Mon, 09 Mar 2015 10:30:16 GMT

Hi Jonathan

Thanks for the app

i couldnot able to fit the code with my data /requirement.

Re: Latitide and Longitude problem

jpenuliar — Mon, 09 Mar 2015 10:39:50 GMT

That is fine, but the basic of presenting your data in google map is there,

you will need a location (city) and a set of coordinates (Lat and Long) and the google api along with the formulas provided

Re: Latitide and Longitude problem

jpenuliar — Mon, 09 Mar 2015 11:09:29 GMT

Here' is another fine example among other tips.

QlikView How To (or Tips & Tricks) Application

by Lee Matthews

http://community.qlik.com/docs/DOC-5486

Re: Latitide and Longitude problem

ThornOfCrowns — Mon, 09 Mar 2015 13:10:10 GMT

Hi Jonathan,

I've added my Google Key into the relevant field, but the map does not show up for me either. Is there anything else needed for it to run?

Thanks.

Re: Latitide and Longitude problem

jpenuliar — Mon, 09 Mar 2015 13:24:59 GMT

Hi James,

I must admit, Although I do have a Google API key, I do not use it.

with or without key works (with limited fetch from Google server) anyway.

Lee Matthews have a good tip on troubleshooting Google map issues.

aside from copy pasting the relevant formulas, from the api guide, issue is most likely your fields Latitude and Longitude not matching the script/variables, Qlikview is case sensitive. It can also be that the api elements and the variables called upon do not match (zoom, maptype, size etc...)

Re: Latitide and Longitude problem

Mon, 09 Mar 2015 13:29:53 GMT

Hi Jonathan ,

but in my sample app, the latitude and longitudes mentioned are same as per the QV .

why cant we able to see the map and also how to show a particular country map with these latitudes and longtitueds?

do we need to add that country's specific image in the image option or how?

could you please ellobrate us?

Re: Latitide and Longitude problem

jpenuliar — Mon, 09 Mar 2015 13:37:52 GMT

I've been playing with your attachment, I managed to make the map image appear on the chart using the dynamic image script I sent you.

I am now stuck with presenting your data coordinates on the grid, I did try to match case your Lat and Long fields and the variables, I did try a chart fast change to straight table to see if you have values from the expression. Somehow, the dots on the chart are off the map. I also found an outer sum() in your Lat and long expression, which I believe is out of place.

Re: Latitide and Longitude problem

Mon, 09 Mar 2015 14:28:18 GMT

this is my concern, i could see the dots in the chart,

even if i able to get the map onto the chart, the cordornitaes are not accurate if i select the region.

I am sorry i didnot get the outer Sum() point in your post.

could you let me know the reason or cant we show the single country co-ordinates with this heat map?

to be exact i need france country to be shown in the chart

Re: Latitide and Longitude problem

jpenuliar — Mon, 09 Mar 2015 15:15:11 GMT

I started from scratch using your excel attachment,

Looks ok to me,

without going back to api guide ver 3.

1. load excel file

2, renamed your LATITUDE and LONGITUDE to Latitude and Longitude.

from QlikView How To (or Tips & Tricks) Application by Lee Matthews

. copy google map script .

4. Scatter Char, used City as Dimension,

5. Copy paste Latitude,Longitude expressions

6.3rd expression for Bubble size = sum(Sales)

7. Copy Axes Scales

8 Copy Dynamic Image

In short, copy the Scatter Chart object from QlikView How To (or Tips & Tricks) Application by Lee Matthews

and change the Dimension and 3rd expression(Bubble size)

Re: Latitide and Longitude problem

Tue, 10 Mar 2015 03:10:20 GMT

Thanks Jonathan for your time and solution.