Some slides describing how to fetch geometry data from MS SQL Server.

In MS SQL STAsText produces WKT that can be read by QGA.

select top(2) zip4, GEOM.STAsText() as wkt from dk_zip4 order by zip4;

Sometimes it's convenient to kick off a geospatial operation in runtime. Since all Qlik GeoAnalytics connector operations are performed at load time the operations are not available as an expression. One way to overcome this limitation is to use on demand app generation (ODAG).

• This small example shows how to kick off travel area calculations for 10 capitals on demand.
• The ODAG start app is used to limit the selection to 10 cities and launch the app with the result.
• The selection is passed from the start app to the template app using ODAG bindings, see load script and documentation for more details.
• The ODAG template app is used for defining the calculations and the look of the result app.

The examples is only possible to run in Qlik Sense Enterprise Server with ODAG turned on.

Qlik GeoAnalytics is required.

Upload the apps to the server with QMC.

Update

Added example with the new simplified ODAG scripting and Dynamic views, see attachment "SelectDV.zip".

Dynamic Views makes it possible to embed a master visualization from the ODAG template in the main application, so the user don't have to spawn a new app.