Error on GMAPS

Wed, 21 Apr 2010 11:42:39 GMT

Dear all, I have a problem sending data to GMAPS

On latitude formula, I obtain null on formula and null on the example

longitude * ((256*pow(2,$(var_zoom)))/360)

I'm testing with the example

This is data on table

latitude	longitude	Country	Population
41.153332	20.168331	Albania	3600523

And this is the obtaines value

Country	longitude	latitude	=longitude * ((256*pow(2,1))/360)
Albania	20.168331	41.153332	-

Can someone help me?

This is the complete table

Country	Population	Country //Pop-up text
Albania	3600523	Albania
Algeria	33858000	Algeria
Argentina	40301927	Argentina
Armenia	3230100	Armenia
Australia	21446187	Australia
Austria	8340924	Austria
Azerbaijan	8629900	Azerbaijan
Bahrain	760168	Bahrain

The load inline:

LOAD * INLINE [
Country,Population,GDP_PPP_M, latitude, longitude
Albania, 3600523, 19621, 41.153332, 20.168331
Algeria, 33858000, 269201, 28.033886, 1.659626
Argentina, 40301927, 523169, -38.416097, -63.616672
Armenia, 3230100, 17139, 40.069099, 45.038189
Australia, 21446187, 760800, -25.274398, 133.775136
Austria, 8340924, 317800, 47.516231, 14.550072
Azerbaijan, 8629900, 64082, 40.143105, 47.576927
Bahrain, 760168, 24245, 25.930414, 50.637772
];

Error on GMAPS

Wed, 21 Apr 2010 11:56:54 GMT

I think it's just an issue with the decimal format

In the script, change the comma in point

SET DecimalSep='.'

regards

Error on GMAPS

Wed, 21 Apr 2010 12:48:58 GMT

But then, It changes on all numbers into the project.

Is any way to do only on longitude / latitude

Thanks

Error on GMAPS

Wed, 21 Apr 2010 13:22:19 GMT

Maybe you can have multiple SET DecimalSep

SET DecimalSep = ',' ;

others data

...

SET DecimalSep = '.' ;

only for long / lat

....

SET DecimalSep = ',' ;

regards

topic Error on GMAPS in QlikView

Error on GMAPS

Error on GMAPS

Error on GMAPS

Error on GMAPS