Skip to main content Skip to complementary content

Using Qlik Geocoding

Once you have purchased Qlik Geocoding, you can use the Qlik GeoOperations connection with Address to point lookup and Point to address lookup. While you can use these functions in any app, it is recommended to build your datasets using the template app available for Qlik Geocoding.

The template app uses an optimal workflow and will help you avoid overusing the limited number of address lookups available with Qlik Geocoding. It stores the points in a QVD file and uses the addresses and points in the QVD file to make sure that addresses that have already been geocoded are not geocoded again.

Download the template app

Download the template app from Qlik Community.

Load the addresses

Replace the example addresses in the Load Addresses section of the load script.

Start with a small list, loading only 10-20 test addresses, making sure to use the same names for fields, remapping if necessary.

For example (test_addresses_400.xlsx):

addresses: First 10 LOAD id, street, city, state, zip, country FROM [lib://DataFiles/test_addresses_400.xlsx] (ooxml, embedded labels, table is addresses);

Modify paths (if needed)

Optionally, modify the paths Qlik Geocoding uses for the space the app is in and the space to which AddressPointLookupResult.qvd will be output. By default, AddressPointLookupResult.qvd is output to your personal space. For guidelines on referrencing specific spaces in the script, see Referring to a data connection in the script.

Run the load script

Run the script. The results will be saved to AddressPointLookupResult.qvd in the specified space.

The QVD file can be imported into other apps, using the “id” field as the key.

Further documentation

For more information on using Address to point lookup in a Qlik GeoOperations connection, see Address to point lookup. For information on scripting using AddressPointLookup, see AddressPointLookup.

For more information on using Point to address lookup in a Qlik GeoOperations connection, see Point to address lookup. For information on scripting using PointToAddressLookup, see PointToAddressLookup.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!