Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now

IP address lookup: coordinates and admin code

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Torbjorn_Soderberg

IP address lookup: coordinates and admin code

Last Update:

Jun 21, 2021 12:57:16 PM

Updated By:

Torbjorn_Soderberg

Created date:

May 31, 2021 9:08:42 AM

Attachments

I am making this post because we are soon switching to a new IP data provider.
The new data contains more ip entries with City name but provides no admin codes
where previously we had admin code for some of the ip entries.

I am sharing two example apps here that shows how to do IP data lookup
followed by a closest operation in order to retrieve the closest admin area
for each IP address.

The app "IPDataUSAdm1Code_GeoConnector.qvf" contains a load script for
Qlik Sense Server/Desktop using the GeoAnalytics connector.
It also contains some sheets that explains how to generate that load script.

The app "IPDataUSAdm1_GeoOperations.qvf" contains a load script that uses
GeoAnalytics operations. GeoAnalytics operations is only available on Qlik Cloud Services.

Both apps contains US ip addresses as examples but the apps should work with
other countries if the list of ip addresses is replaced. Some countries have both a number code and a letter code for their admin areas, if the code retrieved from the operation is not of the type you want there is always the option of retrieving admin name instead.

Tags (1)
Labels (1)
Contributors
Version history
Last update:
‎2021-06-21 12:57 PM
Updated by: