Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
micheledenardi
Specialist II
Specialist II

QlikSense GeoAnalytics Error: Unsuccessful Location Lookup

Hi Guys,

Idevio GeoAnalytics maps return me the error "Unsuccessful Location Lookup" for some location (countries).

Surfing on the net i've found this thread Qlik GeoAnalytics - Troubleshooting a location lookup which is exatly my case, so the problem is that Idevio Map is not able to geo-locate some countries because the country name i'm using is not "mapped" on idevio coutries DB.

Now... to resolve the problem i would like to know which is the correct country name that Idevio Map is able to recognise and geo-locate. Does exists a list of coutries that Idevio Maps is able to recognise ? Is this country list stored in some local file of the extension ?

I would like to avoid using ISO Codes because when i pass over the map with the mouse i want to see the exatly country name and not Codes.

I would also avoid using custom "Info Bubble" to put the coutry name because i like the provided data representation of the "Auto Info Bubble" which is not possible to create/design by using the custom one...

2018-04-18 11_21_14-Service Level (Sviluppo) - SL Weekly Policy BUs (1) _ Fogli - Qlik Sense.png

bpsamzmtobqgslistalwar1

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
1 Solution

Accepted Solutions
Jonas_Karlsson
Employee
Employee

Hi,

You can use the Load operation in the QGA Connector to explore the countries in the location db.

load.png

Use the Country name as dim and the geometry as location measure.

load.png

See the attached app.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Jonas Karlsson

Qlik

View solution in original post

7 Replies
micheledenardi
Specialist II
Specialist II
Author

I've found the solution !

By zoom the Idevio map on the "non geo-located" country/city is possble to see which is the correct country name that Idevio Map is able to recognise and goe-locate!

Before:

2018-04-18 11_57_51-Service Level (Sviluppo) - SL Weekly Policy BUs (1) _ Fogli - Qlik Sense.png

After:

2018-04-18 12_01_37-Service Level (Sviluppo) - SL Weekly Policy BUs (1) _ Fogli - Qlik Sense.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Jonas_Karlsson
Employee
Employee

Hi,

You can use the Load operation in the QGA Connector to explore the countries in the location db.

load.png

Use the Country name as dim and the geometry as location measure.

load.png

See the attached app.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Jonas Karlsson

Qlik

micheledenardi
Specialist II
Specialist II
Author

Great answer Jonas and thanks for the qvf, it's really useful !

Can you tell me why there is an "unmapped" area between Montenegro and Bosnia and Herzegovina ?

2018-04-18 12_28_01-Countries - Countries _ Fogli - Qlik Sense.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Jonas_Karlsson
Employee
Employee

Hi,

According to Natural Earth is this a disputed area, unfortunately, there are some areas like this in the world.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Jonas Karlsson 

Qlik

mangalsk
Creator III
Creator III

Hi

facing  similar issue, no luck.

 

any other option 

rajagenentech
Contributor II
Contributor II

Hi , when I open the Countries app, it has a lib named GA. Could you please specify how did you configure a  connection string to pull the list of countries from the Geo Analytics server Database.