Format to geo

[fkeuroglian]

Hi expert, i would like to know why my excel have correct format and in qlikview it seems to be different

i want this to get latitude and longitude

but the latituted is -53.111111 and in qlikview i see 5311111, do not appear the "." and this not is useful to the geo cordenate

thank you a lot

Fernando

what could be?

i attached and exampole qvw and the excel

[robert_mika]

From my side the values have differently

Example:

What you see in cell is formatting but the real values are in the function box.

What's your source of those data?

[fkeuroglian]

Hi Robert, you have a point, there is no decimal separator(no point)

my original source is the attached, what is the best option to transform to geo point latitude and longitude? what is your opinion

thank you a lot

Fernando

[#4]

Fernando,

I think your problem is similar to the one you had in this post.

You should check your document variables for Decimal and Thousand separators, also check the actual data in the source file (does it contain decimal separators? If so, which is it? etc.) and then you will be able to plot the points in a map.

I believe I used that same data set but with Qlik Sense by the way

[robert_mika]

@Borja

The data set is different

My way was:

-Open with Notepad

-Save as csv.

The problem with your original data set has two coma  delimited fields after latitude an longitude

[fkeuroglian]

Robert, i see the data correct, but do not works in sense using geo data

what could be expert?

[robert_mika]

This is Qlikview podforum.

I can not open qvf file.

maybe is good idea to ask moderator to move this topic o open new one in QS forum.

[#8]

If you use Robert's previous explanation you will get the coordinates properly formatted.

After that, follow the same method I advised on the other post about geo coordinates (make sure the DecimalSep is correct or use the num# function when loading the coordinates and finally apply the GeoMakePoint function).

[fkeuroglian]

Borja, i did this and nothing happend

i have the same problem