Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

florian890
New 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

Tags (1)
1 Solution

Accepted Solutions
dberkesacn
Contributor III

Re: Maps: not all cities automatically recognised

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);

7 Replies
dberkesacn
Contributor III

Re: Maps: not all cities automatically recognised

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

florian890
New Contributor III

Re: Maps: not all cities automatically recognised

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

Re: Maps: not all cities automatically recognised

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
New Contributor III

Re: Maps: not all cities automatically recognised

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

Re: Maps: not all cities automatically recognised

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

Re: Maps: not all cities automatically recognised

Hi @florian890,

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

Thanks,

Daniel

florian890
New Contributor III

Re: Maps: not all cities automatically recognised

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!