Latitide and Longitude problem

[#1]

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.

[jpenuliar]

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...)

[#3]

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?

[jpenuliar]

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.

[#5]

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

[jpenuliar · Accepted solution]

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)

[#7]

Thanks Jonathan for your time and solution.