topic Google Maps Plotting Issue in QlikView

Google Maps Plotting Issue

Sun, 07 Nov 2010 19:31:21 GMT

I am using the personal edition of Qlikview and am trying to map locations using the google map static map api. I have about 3,000 records and am able to get the google map to display with the locations pinned to the map but the locations are not aligned properly to their lat, lon.

I have used the code in the example su[pplied with Qlikview. I am using a unique identifier, a seven digit number as the dimension. on the expressions tab of the map my expressions ar for latitude, longitude and sum of sales.

The definition of the longitude and latitude expression,

avg( round (256*pow(2,($(var_zoom)-1)))+( longitude *((256*pow(2,$(var_zoom)))/360)) )

avg

(

((

256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi

()))))

changes the X and Y value to a field other than Latitude and Longitude and the definition ends up being Sum ([longitude]) and Sum ([latitude]).

I suspect this may be the issue but I have not been able to solve the problem so the data displays properly.

Any help would be appreciated.

Google Maps Plotting Issue

Sun, 07 Nov 2010 20:11:19 GMT

Hi,

Could you post your app, I'll take a look.

Are you sure Long / Lat are in the correct projection (WGS84) ?

JJJ

Google Maps Plotting Issue

Sun, 07 Nov 2010 22:12:38 GMT

Thank you for your quick response.

For code, I am using the example that comes with Qlikview. It was my understanding from reading the documentation that since the Google Map static API was based on the mercator projection that the calculus in Qlikview modified the Lat Lon coordinates so they could be accurately placed over the Google Map.

Here is an example

The expressions tab of the chart properties (advanced mode) has sum ([Longitude]) or sum ([latitude]) in the definirtion of the label rather than the code that is in the example. When I insert the code from the example in the label definition box, then the X and Y values change to another field in my data that makes the map disappear.

Thanks for considering a solution to this dilema.

Google Maps Plotting Issue

deepakk — Mon, 08 Nov 2010 04:43:10 GMT

HI,

I am just guessing it.Since the variable $(var_zoom) is shown in red colour I think u have not declared it properly.

Google Maps Plotting Issue

Mon, 08 Nov 2010 21:08:33 GMT

Very strange Map ! where are the coordinates from ?

Please send the file with just the Long/Lat I will check

JJJ

Google Maps Plotting Issue

Wed, 10 Nov 2010 03:25:04 GMT

I have attached the lat lon file.

Thaks for reviewing

Google Maps Plotting Issue

Anonymous — Wed, 10 Nov 2010 03:29:59 GMT

See if the checkbox "Plot Area Only" is checked. If not, you get the map shifted, and the data points are not in the right places.

Google Maps Plotting Issue

Wed, 10 Nov 2010 21:12:36 GMT

Hi,

Finally it's not var_zoom or the suggestion of Michael or a projection problem.

I built a little example with you coordinates. As you can see, it seems smart. I've just add an Id and some datas (Sales, Type).

I can't explain what is wrong in your app maybe an option you checked but i suggest you to use my chart and integrate your data

Regards

Google Maps Plotting Issue

Thu, 11 Nov 2010 00:13:58 GMT

Thank you for taking time to assist me. However, since I am using the personal version of Qlikview, I cannot open your file.

😞

Google Maps Plotting Issue

Thu, 11 Nov 2010 09:01:34 GMT

I'm also with a personal edition in v10.

Do you have a valid licence key ? what is your version ?

Google Maps Plotting Issue

Thu, 11 Nov 2010 09:07:15 GMT

@jean-jacques Jesua: you can get a valid qlikview license key if your company is a Qlikview Partner.

Google Maps Plotting Issue

Thu, 11 Nov 2010 09:29:06 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/674/0576.Lat-Lon-used-in-Qlikview.xlsx:550:0]

try to use this file as a source..

then in your scatter chart; use ID as your Dimension..

*make sure that your code in your script editor match the case of the fields(Longitude and Latitude).

Google Maps Plotting Issue

Fri, 12 Nov 2010 18:07:32 GMT

I save the app in QV 9.

Check if you can open it

Regards

JJJ

Google Maps Plotting Issue

Fri, 12 Nov 2010 20:38:49 GMT

The problem has been solved. Your suggestion to check the case of latitude and longitude was the key!!! Tha capital "L" kept the map from displaying properly. Whodathunkit?

Thank you so much.