GoogleMaps integration without succes

[intervigilium]

From all forums i gathered all information to make an integration of google maps within my Qlikview application.

Finally i got it working for 95%? Qlik is showing a map, but the coordinates are not plotted right....

If i check the sample coordinates, it should be a place in the Netherlands, and not in the middle of the ocean (see example).

I tried so many things (importing strings, integers, with dot or comma.... all without the right result. If just copy the coordinates to Google Maps it is working (. instead of .)

Google Maps

Who knows what i am doing wrong?

[intervigilium]

I tried a lot more in meantime... and i rebuilded the model.

Now i have only 1 'small" problem:

The longitude and latitude i converted to number (not getting it using an API, just have them in an csv).

Calculating the mean latitude and longitude is not giving an good value....

How to fix this? Tried to declare the variables.

Thanks for any help!

[intervigilium · Accepted solution]

In meantime i made the problem smaller to reduce the sample to only the formatting of the variable.

With help on that topic the problem was mainly solved.

For anyone who has this problem in future, to solve it:

Add:

SET ThousandSep=',';

SET DecimalSep='.';

to the script.