Qlik Community

Qlik Sense Documents

Qlik Sense documentation and resources.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

GeoOperations Examples Qlik GeoAnalytics

Patric_Nordstrom
Employee
Employee

GeoOperations Examples Qlik GeoAnalytics

Examples and guides for the Qlik GeoOperations. The examples are self sufficient with data and reloadable. The examples are minimal to explain to basic functionality. Please use the documentation for details of the operations. The examples works on Qlik SaaS and QSEoK and requires a GeoAnalytics license.

GeoOperations is simple, for instance, here's how to load a shapefile:

Load * Extension GeoOperations.ScriptEval('
load() DATASOURCE shape GEOFILE type="shape", 
url="https://dl.dropbox.com/s/ipi6tazxwkbuzu6/continents.zip?dl=0")';

 

GeoOperations Examples.qvf: Example with all basic operations

  • Binning
  • Cluster
  • Closest
  • Dissolve
  • Intersect
  • Load
  • Routes
  • Simplify
  • TravelAreas
  • Within

GeoOperations BigQuery.qvf : Example how to load from Google Big Query (requires a Google BigQuery license and instance).

GeoOperations CSV example.qvf : Example how to use more than one internal table as input.

Qlik Geocoding in GeoOperations.qvf : Example how to use Geocoding, TravelArea and Closest in runtime (requires a Qlik Geocoding license).

Note,  please use the GeoOperations template for Qlik Geocoding, available here: https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Qlik-Geocoding-Geocoding-Template-Data-and...

 

 

Tags (1)
Labels (3)
Attachments
Comments
julian_rodriguez

Hello Patric,

Good examples, however, I'd like to test the cluster operation with my own data. ¿Could you provide me an example, please?

thanks

Julian

0 Likes
Patric_Nordstrom
Employee
Employee

@julian_rodriguez  it's very similar to how to do Binning from points, here's an example. Loading first airports and store as points. Then use the points as indata.

 

cp_ap:
Load * Extension GeoOperations.ScriptEval('
	Select Name as cp_ap, LocationPoint as cp_ap_pt from
    Load() DATASOURCE cp_ap LOCATIONSERVICE geometry="POINT", type="XIATA", country="us"
');

cp:
Load * Extension GeoOperations.ScriptEval('
  Select INTABLE.cp_ap as cp_ap, ClusterID as cp_id, Clusters.ClusterPoint as cp_pt from
  Cluster(distance="500000")
', cp_ap;

 

0 Likes
Version history
Last update:
‎2021-04-02 05:04 AM
Updated by: