Creating a map from point data in an Excel file

[Anonymous]

Hi All,

Below is my location data. How to create geopoint 

Location	Latitude	Longitude
Texas	31.9686	-99.9018
Florida	27.66483	-81.5158
Rome	41.90278	12.49637
Bern	46.94797	7.447447
Bangalore	12.9716	77.59456
Singapore	1.355379	103.8677
Perth	-31.9505	115.8605
Chennai	13.08268	80.27072
Ohio	40.41729	-82.9071

Regards,

Krishna

[YoussefBelloum]

Hi Krishna,

Geopoints are the coordinates you already have on the table attached (latitude, longitude)

you table is ready for the Qliksense map.

you only need to use the GeoMakePoint function to start

GeoMakePoint  - script and chart function ‒ Qlik Sense

on the Load, make this:

Table:

LOAD

.

.

GeoMakePoint(Latitude, Longitude) as THE_NAME_YOU_WANT

.

.

FROM...

Also when you use the Load assistant, Qliksense can automatically recognize a country field for example and will create for you the coordinates

[agigliotti]

take a look at GeoMakePoint - script and chart function ‒ Qlik Sense