Error

[smilingjohn]

Hi ALl

I have implemented the Map ,and after reloading on top right side of the map image iam geting an error as shown in the snap shot

I dont know what needs to be done .....

Iam using the below expression under dynamic image

='http://maps.google.com/maps/api/staticmap?center='  &  num(var_mid_lat, '##############', '.', ',' )  &  ','  &  num(var_mid_long, '##############', '.', ',' )  &  '&zoom=$(var_zoom)'  &  '&maptype='&var_maptype  &  '&size='&map_size_x&'x'&map_size_y  &  '&sensor=false'

Can somone please help me , how do i get rid of thie error message ?

[Kushal_Chawda]

Can you please share the qvw file?

[smilingjohn]

Hi Kushal

Here is the sample qvw iam implementing it even doesnt show proper location ...

[hector_munoz]

Hi John,

I think your problem is that the name of the fields in the original XLS file (capitalized e.g. Latitude) is not used in map variables (lowercased latitude😞

Map:

LOAD City,

    Latitude,

    Longititude,

    Employee

FROM

(ooxml, embedded labels, table is Sheet6);

var_mid_lat=

'=min(latitude)+(1+var_lat_offset)*((max(latitude)-min(latitude))/2)';

The easiest way to sove this is renaming XLS fields and expression fields:

Map:

LOAD City,

    Latitude     AS latitude,

    Longititude  AS longitude,

    Employee

FROM

(ooxml, embedded labels, table is Sheet6);

I hope it serves!

Regards,

H

[Frank_Hartmann · Accepted solution]

see attached file

hope this helps