Skip to main content

Qlik Sense GeoOperations features

ON THIS PAGE

Qlik Sense GeoOperations features

Qlik Sense GeoOperations is a toolbox of functions that enables geographic analysis in Qlik.

Here is a list of features, operations, and supported formats.

Features

  • Available in the script language in Qlik Cloud with an add-on license.

  • Extracts spatial relations so that they can be handled by Qlik.
  • Load time lookups of locations (as an alternative to the presentation time lookups in the map chart).
  • Aggregation of points in clusters or bins.
  • Specify locations as:
    • Point, line, or area geometries in the same format as QlikGeoAnalytics and Qlik Sense
    • Latitude and longitude fields
    • Named points or areas
  • Load geographic data from a range of formats.
  • Use operations to data already loaded in Qlik.

Geometric operations

  • Closest – Finds N closest objects in a dataset closer than a specific distance from every object in another dataset. Uses and calculates either direct distances or distances along roads.
  • Intersects – Finds intersecting objects in two datasets. It also calculates how much areas intersect.
  • Dissolve – Creates custom areas, e.g. Region A = Zip 1, 2, 5. Region B = Zip 3, 4, 6.
  • Within – Creates relations between all entities in a table that are within areas specified in another table.
  • Simplify – Generalizes geometries so that they look better and are faster to use in more zoomed out scales. Most external data needs to be simplified before use.

Aggregating operations

  • Cluster – Groups points that are within a specified threshold distance. Useful for datasets containing a large number of points.
  • Binning – Another method of clustering that creates hexagonal or rectangular bins.

Route-based operations

  • Closest – Finds N closest objects in a dataset closer than a specific distance from every object in another dataset. Uses and calculates either direct distances or distances along roads.
  • Routes – Get routes and distances between origin points and destination points in a dataset.
  • TravelAreas – Get the areas reachable from origins in a dataset within a certain time or distance. Defaults to travel along roads, but direct distances can also be used.

Lookup operations

  • AddressPointLookup – Get the point of an address, i.e. forward geocoding. Requires separate Qlik GeoCoding license.
  • PointToAddressLookup – Get the address close to a point i.e. reverse geocoding. Requires separate Qlik GeoCoding license.
  • IpLookup – If you have IP addresses in your data, you can use them as geographic locations

Other operations

  • Load – Load data from all supported data sources (ex. shape-files, GeoJSON, etc…)

Data source formats

  • Loaded tables – Operates on tables loaded in Qlik
  • QlikGeoAnalytics Location database – Gives access to millions of points and areas such as countries, administrative areas, cities, postal codes
  • ESRI Shape file – Probably the most common geographic file format
  • ESRI JSON – For easy access to services in ArcGIS Server
  • GeoJSON – JSON based format for geographic data
  • Separated text files – Simple text files such as CSV