Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

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: