topic Re: Error in QlikView

Error

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: Error

Kushal_Chawda — Wed, 28 Jun 2017 10:11:38 GMT

Can you please share the qvw file?

Re: Error

smilingjohn — Wed, 28 Jun 2017 10:26:16 GMT

Hi Kushal

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

Re: Error

hector_munoz — Wed, 28 Jun 2017 11:32:00 GMT

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,

Re: Error

Frank_Hartmann — Wed, 28 Jun 2017 11:43:30 GMT

see attached file

hope this helps