Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
florian890
Contributor III
Contributor III

Maps: not all cities automatically recognised

Dear all,

I run into more and more places which are not automatically geotagged in the system.

How can I make the system use geocoordinates if I have them in my xls file?

Thanks once more,

Florian

1 Solution

Accepted Solutions
dberkesacn
Partner
Partner

here is an example:

[LongLati2]:

LOAD [AccentCity],

[Latitude],

[Longitude],

  GeoMakePoint(Latitude,Longitude) as GeoPoint

FROM [lib://Mapping/LongLati2.txt]

(txt, utf8, embedded labels, delimiter is ',', msq);

MapMap:

Mapping Load

[AccentCity],

    GeoPoint

Resident LongLati2;

drop table LongLati2;

[Sheet1]:

LOAD [City],

[Value],

    ApplyMap('MapMap',[City], 'N/A') as GeoPoint

FROM [lib://Mapping/testdata01.xlsx]

(ooxml, embedded labels, table is Sheet1);

View solution in original post

7 Replies
dberkesacn
Partner
Partner

I think the only possibility is a mapping table. Could you mention some example where qlik hasn't recognized the places?

florian890
Contributor III
Contributor III
Author

Thanks for your feedback!

e.g. Cham in Switzerland, CH or But in France (78535 post code) or Oakwood Village (Ohio) USA even though Oakwood I have not completed verification...

Thanks for your kind help,

Florian

dberkesacn
Partner
Partner

This site CSV has Cham, maybe you can use this file as a geo file and map it in your data model.

https://www.maxmind.com/en/free-world-cities-database

line: 387611

ch,cham,Cham,24,13431,47.182126,8.463576

florian890
Contributor III
Contributor III
Author

Great, thank you for your feedback. Now the question is: how do I map something in?

Should I close this discussion and open a new one or are you still willing/patient enough to help further?

dberkesacn
Partner
Partner

here is an example:

[LongLati2]:

LOAD [AccentCity],

[Latitude],

[Longitude],

  GeoMakePoint(Latitude,Longitude) as GeoPoint

FROM [lib://Mapping/LongLati2.txt]

(txt, utf8, embedded labels, delimiter is ',', msq);

MapMap:

Mapping Load

[AccentCity],

    GeoPoint

Resident LongLati2;

drop table LongLati2;

[Sheet1]:

LOAD [City],

[Value],

    ApplyMap('MapMap',[City], 'N/A') as GeoPoint

FROM [lib://Mapping/testdata01.xlsx]

(ooxml, embedded labels, table is Sheet1);

dberkesacn
Partner
Partner

Hi @florian890,

has my answer solved your issue, if yes pls also hit the correct answer option.

Thanks,

Daniel

florian890
Contributor III
Contributor III
Author

It has not since I am not yet strong enough in scripting. But since I am full of faith that you did answer I agreed 🙂

Thanks again for all ur help!