Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error on GMAPS

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.15333220.168331Albania3600523


And this is the obtaines value

Countrylongitudelatitude=longitude * ((256*pow(2,1))/360)
Albania20.16833141.153332-




Can someone help me?

This is the complete table

CountrylongitudelatitudePopulationCountry //Pop-up text
Albania3600523Albania
Algeria33858000Algeria
Argentina40301927Argentina
Armenia3230100Armenia
Australia21446187Australia
Austria8340924Austria
Azerbaijan8629900Azerbaijan
Bahrain760168Bahrain


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
];





3 Replies
Not applicable
Author

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

In the script, change the comma in point

SET DecimalSep='.'

regards

jj

Not applicable
Author

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

Is any way to do only on longitude / latitude

Thanks

Not applicable
Author

Maybe you can have multiple SET DecimalSep

SET DecimalSep = ',' ;

others data

...

SET DecimalSep = '.' ;

only for long / lat

....

SET DecimalSep = ',' ;

regards

JJ