For most geo-related use cases, the highest level of needed detail is the town or postal code district. There are, however, certain use cases where one needs to also include street addresses.  And for that, Qlik now offers Qlik Geocoding.  Initially released this past April, Qlik Geocoding is an optional, add-on subscription service to Qlik GeoAnalytics Base and Qlik GeoAnalytics Enterprise Server that determines the coordinates of a street address or the other way around.


The service is provided through the Qlik GeoAnalytics Connector (for both QlikView and Qlik Sense) using the operations “AddressPointLookup” and “PointToAddressLookup”. “AddressPointLookup” is used for forward geocoding (given this address, what are the coordinates).  “PointToAddressLookup” is used for reverse geocoding or converting coordinates to an address.  This could be useful, for example, to convert GPS coordinates to a street location.


An example of forward geocoding can be seen in this screenshot.  The original addresses are in the table on the left.  The related coordinates that were returned by Qlik Geocoding are in the table on the right.


Qlik’s source of geocoding information is the Esri World Geocoding Service and, like any mapping source, the completeness and level of detail will vary by country.  Countries with rich datasets should accurately return the correct house number.  Countries with limited datasets may only be able to match to the street or region, not the address.


Qlik Geocoding is only offered as a hosted service and is subscription priced based on how many lookups are done each year.  Because of this, we recommend that you store all completed look-up results locally for future reference.  Thus, you only need to use Qlik Geocoding in the future for new addresses.  This can significantly reduce the number of address lookups and thus minimize the cost of using Qlik Geocoding.


To learn more about our Qlik Geocoding service check out this video by our Mike Tarallo, which provides a brief presentation about the service and a more in depth how-to with some tips and tricks along the way. Mike has also provided some sample data and a Qlik Sense example as well for you to use within your Qlik Sense implementation. Also see his next video which covers the Line Layer and the use of the "Closest" operator with the Qlik GeoAnalytics Connector: Get Familiar with Qlik GeoAnalytics - The "Closest" Operator.




Resources mentioned in this video:

Qlik GeoAnalytics

Terms and Conditions

• Geocoding Template:

Since we launched Qlik GeoAnalytics about a year ago, there has been great interest among both Qlik Sense and QlikView users in adding mapping and geo-analysis capabilities to their Qlik environment.  Now we are making it even easier.  Starting with Qlik Sense April 2018, we updated the mapping capabilities within Qlik Sense to be based on Qlik GeoAnalytics technology.


This new map chart object makes it easy to add maps to your app.  Location related names such as countries, counties, provinces, regions, cities, airports, and zip codes now utilize a dynamic location name lookup service to automatically define and visualize geo data.


This new capability is available to all Qlik Sense users, whether they are using Desktop, Enterprise or Cloud.  Additional Qlik GeoAnalytics features such as multiple layers, layer control, zoom levels, labels, and multiple point symbols are also included.  And if you have maps in your existing apps, they will be seamlessly migrated to the new map object.


Points and area layers are available in this initial release.  Additional layers and more capabilities are planned for future releases. Note that all geo-analysis calculations, such as drive-times, travel areas, binning, clustering or intersections, still require a different license.


If you haven’t seen it yet, some of these new mapping capabilities can be found in the video - What’s New in Qlik Sense April 2018.  Click on the image below to watch the video.


2018-05-09 12_06_00-Clipboard.png

Some of you may have already tried the animator tool that comes with Qlik GeoAnalytics.  The extension allows you to easily animate data in a map.  The algorithm for the animator is pretty straight-forward – charts and tables are visually updated as the animator progresses through each data point within a selected dimension.  You have the option to aggregate the data while the Animator progresses.  You can also animate in a continuous loop.


For example, you could animate the appearance of new stores on a map according to their opening date. Assuming there was a dimension like StoreOpenDate, new store locations would appear on a map as the Animator steps through each date in the StoreOpenDate dimension.


The Animator is already available in Qlik GeoAnalytics for Qlik Sense.  With the release of Qlik GeoAnalytics November 2017, the animator tool is also now available in Qlik GeoAnalytics for QlikView.


But did you know that the Qlik GeoAnalytics Animator can be used with any chart, not just a map?  Bar charts, histograms and tree maps can come to life.  And the dimension used by the Animator doesn’t have to be a time-based variable. So in addition to months, dates or hours, you could animate according to season, product code, account type, age span, etc.


Tip – If you want to minimize the visual jumpiness of a chart as the animation progresses, define the min and max of the Y axis to set values instead of Auto Range.


The tool is fairly simple to use.  Here’s a short example:


More details about the Qlik GeoAnalytics Animator can be found in the Qlik online help here

QlikGeoAnalytics-Typemark-Vertical-RGB-1.pngLate last year, a major highway in the Boston area changed to be completely electronic.  Gone are the toll booth plazas and people.  They’ve been replaced by overhead gantries at various points along the highway that read vehicle transponders as they pass underneath. Don’t have a transponder?  A camera takes a picture of your license plate and sends you the bill.


The result is a deluge of data on the 100,000+ vehicles that use the highway every day.  You can now go online and see that Thursdays and Fridays are the busiest days of the week and very few people go over 75 mph.  (they say they won’t use this data to issue speeding tickets.  We’ll see…..).


I think this situation is typical of many organizations who are suddenly finding themselves with an abundance of geo-spatial data.  But is the highway department taking full advantage of this location-based content?  Are they able to not just visualize this data, but fully understand it and how it relates to other information?  For example, is there a relationship between traffic volumes and rest stop usage? What effect, if any, does different weather conditions have on traffic speed?  Or have their marketing campaigns had an impact on transponder usage in different parts of the state?


Enter Qlik GeoAnalytics. Just like QlikView and Qlik Sense has allowed tens of thousands of organizations to not only visualize their data but better understand it in ways they never thought possible, Qlik GeoAnalytics gives you the same power with your location-related data.


READ MORE: 2017 Dresner Report: Qik Rated #1 for Location Intelligence Capabilities


Qlik GeoAnalytics has already been used by customers in many different situations – determining the best location for a new store based on existing client information, population data and driving distances.  Analyzing weather-related insurance claims vs. actual weather data to determine possible cases of fraud.  Understanding foot traffic within a store by taking real-time customer tracking data (via cell phone Wi-Fi signals) and overlaying it on an image of the floor plan.  There are many different industries and business functions that can take advantage of Qlik GeoAnalytics.


Interested in finding out more?  Check out these demos, videos and tutorials.  And be careful how fast you drive on the highway because someone may be watching you….


READ MORE: Data Visualization Foundations: Mapping Point Data | Qlik



What’s Cooking @ Qlik

This information and Qlik‘s strategy and possible future developments are subject to change and may be changed by Qlik at any time for any reason without notice. This information is provided without a warranty of any kind.  The information contained here may not be copied, distributed, or otherwise shared with any third party.


Qlik GeoAnalytics joined the Qlik product portfolio just a few short months ago through the acquisition of one of our partners, Idevio.  We will certainly see more from Qlik GeoAnalytics over the coming year but it is bit too early to share any specifics here.   However, we are all very excited to have them as part of the family and look forward to a great year!

READ MORE: Press Release announcing Idevio acquisition