Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

Geo Problem Sense

Hi expert, i have data in csv and i want to represent via map using sense

i have some error what could be, the mag see but not all te coordenate (lat,long) seems ok

thank you

Fernando

9 Replies
Michael_Tarallo
Employee
Employee

Hello Fernando -

I am looking into this - I tested the coordinates with this tool: http://www.darrinward.com/lat-long/?id=516867 and they seemed valid - yet I am getting this in Qlik Sense:

I will let you know what I find.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
fkeuroglian
Partner - Master
Partner - Master
Author

Michael, I have the same results as you.

tell me if you can help me and see what could be

thank you a lot

Fernando

Patrik_Lundblad
Employee
Employee

Hi Fernando,

In your csv file you are using . (dot) as decimal separator. But in your load script it's defined as , (comma).

So if you change the top two rows to th3 below script it should work better.

SET ThousandSep=',';

SET DecimalSep='.';

Regards,

Patrik

fkeuroglian
Partner - Master
Partner - Master
Author

Thank you Patrick, but nothing happend with these change

Fernando

Patrik_Lundblad
Employee
Employee

Did you do a reload and did you also create a new map object?

If so can you create a table and add in the latitude, longitude and geokey fields and then post a screenshoot?

Regards,

Patrik

fkeuroglian
Partner - Master
Partner - Master
Author

Patrick

Thank you

i previous attahed the .csv and the qvf

Patrik_Lundblad
Employee
Employee

Fernando,

The GeoKey field still looks wrong and the values are in the thousands, try this app.

Regards,

Patrik

fkeuroglian
Partner - Master
Partner - Master
Author

Thank you patrick, i have this reslult previous, but the map is rare ,not?

Patrik_Lundblad
Employee
Employee

There is currently a limitation in the amount of points we plot on a map (1,000). If you start doing selections on regions or something similar you will see other points show up.

It's something we are working on improving and the limitation will be removed in a later release.

Regards,

Patrik