topic Re: Format to geo in QlikView

Format to geo

fkeuroglian — Tue, 31 Mar 2015 19:55:05 GMT

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

Re: Format to geo

robert_mika — Wed, 01 Apr 2015 07:32:25 GMT

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?

Re: Format to geo

fkeuroglian — Wed, 01 Apr 2015 14:07:57 GMT

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

Re: Format to geo

Wed, 01 Apr 2015 14:13:38 GMT

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

Re: Format to geo

robert_mika — Wed, 01 Apr 2015 14:33:17 GMT

@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

Re: Format to geo

fkeuroglian — Wed, 01 Apr 2015 16:53:59 GMT

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

what could be expert?

Re: Format to geo

robert_mika — Wed, 01 Apr 2015 17:06:01 GMT

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.

Re: Format to geo

Wed, 01 Apr 2015 17:12:06 GMT

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).

Re: Format to geo

fkeuroglian — Wed, 01 Apr 2015 18:56:18 GMT

Borja, i did this and nothing happend

i have the same problem