Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Not applicable

How should I create a map loading geographic data?

I tried to create a map loading geographic data. A customer base with the latitude and longitude of each client but it does not show the points on the sheet inside my map.

The format of my file is EXCEL:

     

CompanyNameCountryCityCityLatitudeCityLongitude
Company1ArgentinaBuenos Aires-34.60639-58.37383
Company2ArgentinaRosario-32.945081-60.642199
Company3ArgentinaCordoba-31.423370-64.177876

The steps I took are the following:

1- Create a new app called maps

2- Add data from the data manager

3- In the data loader I unlocked "Automatically generated section"

And modified the upload script:

LOAD

    CompanyName,

    Country,

    City,

    CityLatitude,

    CityLongitude,

    GeoMakePoint(CityLatitude,CityLongitude) as CityMapPoint

FROM [lib://Sense/Mapas.xlsx]

(ooxml, embedded labels, table is [Reports (10)]);

4- I clicked "Upload Data"

5- Create a new sheet and drag a map

6- I added the dimension "City"

But it did not show me the points.

What is the problem?

Thanks for your helps!

Tags (2)
1 Reply
jneppl
New Contributor II

Re: How should I create a map loading geographic data?

Hey, your data from CityLatitude and CityLongditude has to be with comma and not with point.

Company1ArgentinaBuenos Aires-34,60639-58,37383
Company2ArgentinaRosario-32,945081'-60,642199

I was using bubble layer with dimension "City" and for Latitude / ID use CityLatitude, for Longitude use CityLongitude.

That worked for me.

Regards

Community Browser