Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
Partner
Partner

Format to geo

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

Tags (3)
8 Replies

Re: Format to geo

From my side the values have differently

Example:

01-Apr-15 8-29-20 AM.jpg

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

What's your source of those data?

Partner
Partner

Re: Format to geo

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

Not applicable

Re: Format to geo

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

@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

01-Apr-15 3-36-51 PM.jpg

Partner
Partner

Re: Format to geo

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

what could be expert?

Re: Format to geo

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.

Not applicable

Re: Format to geo

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

Partner
Partner

Re: Format to geo

Borja, i did this and nothing happend

i have the same problem