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 Services and Qlik Sense Enterprise on Kubernetes 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

  • 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

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?