Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fkeuroglian
Honored Contributor

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

Tags (1)
9 Replies
Employee
Employee

Re: Geo Problem Sense

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

fkeuroglian
Honored Contributor

Re: Geo Problem Sense

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

plu
Contributor III

Re: Geo Problem Sense

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
Honored Contributor

Re: Geo Problem Sense

Thank you Patrick, but nothing happend with these change

Fernando

plu
Contributor III

Re: Geo Problem Sense

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
Honored Contributor

Re: Geo Problem Sense

Patrick

Thank you

i previous attahed the .csv and the qvf

plu
Contributor III

Re: Geo Problem Sense

Fernando,

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

Regards,

Patrik

fkeuroglian
Honored Contributor

Re: Geo Problem Sense

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

plu
Contributor III

Re: Geo Problem Sense

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