Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Thank you Patrick, but nothing happend with these change
Fernando
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
Patrick
Thank you
i previous attahed the .csv and the qvf
Fernando,
The GeoKey field still looks wrong and the values are in the thousands, try this app.
Regards,
Patrik
Thank you patrick, i have this reslult previous, but the map is rare ,not?
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