GeoAnalytics Reference

GeoAnalytics Reference

Version: April 2018, Date: 2018-03-27

Documentation of operations and data sources available in the GeoAnalytics wizard and query language.

Contents

OperationDataset

Operation

AddressPointLookup

This operation is licensed separately and then only available in the cloud service.

Returns point geometries for each address in a table, i.e. geocoding. Addresses that could not be lookup for any reason is not returned in the result. Specify either an address string in the Search Text property or structured parts in the corresponding properties, such as Country, Street etc. Combinations are also allowed. A recommendation is to not specify redundant parts which might confuse more than they help. If you for instance have both postal code and postal city and you trust that postal code is correct, then it is best to not specify postal city. It is recommended to always specify country.

The returned table contains the fields for (values can be empty where data is not available or not applicable):

  • Key field - same as the key field for the name table
  • Address - The found address, formatted to the address standard of the country
  • Geometry - The point for the found item
  • HouseNumber - The house number for the found item
  • Street - The street for the found item
  • PostalCode - The postal code for the found item
  • City - The postal area name for the found item
  • Adm1Code - The code for the first order administrative area (state) for the found item for countries where that is a part of the address
  • CountryIso2 - The country code for the found item
  • Match - A value between 0 and 1 that tells how good the match was. 1 means perfect.
ParameterTypeUseDescription
Search Textstring optional A field for unformatted addresses to search for. Can be addresses like: "1600 Pennsylvania Ave, Washington DC, USA" or incomplete addresses that is combined with data in other fields, like "1117 Washington Ave" and with City set to "Philadelphia" and Country set to "USA".
Countrystring optional Country name or 2 or 3-letter ISO code. Can be set to a constant string instead of a field name. A constant string should be enclosed in double quotes.
Statestring optional State name or code. For most countries the state is not part of the address. Can be set to a constant string instead of a field name. A constant string should be enclosed in double quotes.
Citystring optional City name, municipality or postal city. Can be set to a constant string instead of a field name. A constant string should be enclosed in double quotes.
Postal Codestring optional Postal code. Instead of specifying postal code and city in separate fields it is allowed to specify both in this field, separated by a space. Can be set to a constant string instead of a field name. A constant string should be enclosed in double quotes.
Streetstring optional Street name. Instead of specifying street and house number in separate fields it is allowed to specify both in this field, separated by a space. Can be set to a constant string instead of a field name. A constant string should be enclosed in double quotes.
House Numberstring optional House number. Can be set to a constant string instead of a field name. A constant string should be enclosed in double quotes.
Match Thresholdrealdefault:0.9 Return only result with a better match than this.
Address TableDataset A dataset with addresses that will be looked up in the geocoder.
Preferred Languagestringdefault: The 2 letter language code of the preferred language in the reply. Will return names in the specified language where available. Note that most items only are available in the local language. Default is to return in the local language.
Service to use for lookupstringdefault:default Name of geocode service to use at the server.

Binning

Generates rectangular or hexagonal bins for a point dataset. Generates a table with the bin geometries with a field that is an association to the original dataset.
ParameterTypeUseDescription
Shape of binsdefault:Rectangular Defines if "Rectangular" or "Hexagonal" bins should be generated.
Side length of binsreal The height of an individual bin (in degrees, note, one degree is approximate 10000 m).
Bin width-height-ratiorealdefault:1.5 The width height ratio of bins. Optimal is often square bins but that varies by latitude. The formula for the optimal width height ratio is 1/cos(latitude), for example 1 at the equator, 1.15 at latitude +-30 deg and 2 at latitude +-60 deg.
Point DatasetDataset The dataset with point geometries to generate bins for.

Closer

Deprecated. Use closest instead with high closest count.

Closest

Returns relations and distances between objects in one dataset and the closest n objects in another, if any is closer than the maximum distance. Adds a field called <dataset1 name>_<dataset2 name>_Distance with the distance in the specified cost unit (default meters) between the objects. The cost may also be calculated along roads and in that case optionally use travel time. This operation is useful in many cases, not only for getting the relations to the closest but also for getting distance matrices between a set of points.

ParameterTypeUseDescription
Maximum cost (distance) between geometriesreal Maximum distance in in the unit specified in Cost unit.
Cost unitstringdefault:meters Should be one of meters, yards, kilometers, miles, seconds, minutes, hours. Using time units imply that the travel time is used as the cost and length units that the distance is used. The time units are not allowed for Distance type Bird.
Distance typerealdefault:Bird Decides how distances are measured. The following values are allowed:
  • Bird - measure birds distances between objects
  • Car - measure along roads with car restrictions, only supported for point datasets
  • Bike - measure along roads with bike restrictions, only supported for point datasets
  • Pedestrian - measure along roads with pedestrian restrictions, only supported for point datasets
  • Truck - measure along roads with truck restrictions, only supported for point datasets
Closest countrealdefault:1 Number of objects in the second dataset to associate with an object in the first dataset. A value of 1 means only the closest, 2 means the two closest and so on.
Dataset containing geometries to measure fromDataset Objects to check for closeness to objects in dataset2 if specified, otherwise to objects in itself. When checking closeness between objects in a single dataset relations are never added from an object to itself.
Dataset containing geometries to measure toDataset optional Objects to relate to objects in dataset1

Cluster

Produces clusters from a point dataset. Returns a table with relations between points and clusters. Also returns a table named Clusters with cluster geometries. It contains the fields ClusterID, ClusterCenter (point geometry) and PointCount. The count field contains the number of points in the cluster.

ParameterTypeUseDescription
Distancereal The distance between a point and its cluster is not longer than this distance in meters.
Point DatasetDataset A dataset with points to cluster.

Dissolve

Dissolves and simplifies areas to form larger areas based on a mapping between old area identities (or geometries) and new area identities. This is typically used for building custom areas that are build up by smaller well defined areas, such as postal areas of administrative areas. Returns a table with the fields:

  • <Dissolve Field> - association via the dissolve field
  • <Dissolve Field>_Geometry - the geometries of the dissolved areas.

The geometry dataset is optional. If not provided, geometries are supposed to be available in the dissolve definition dataset.

Note that overlaps of polygons are removed in all resolutions except Source.

ParameterTypeUseDescription
Dissolve Fieldstringdefault:<same name as the key field in dataset> The name of the field with identities of the new areas in the dissolve definition dataset.
Resolutionstringdefault:Auto The resulting dataset is simplified and the degree of simplification is controlled by this property. Available values are:
  • Auto - The operation calculates a resolution based on the data that often is OK.
  • Auto low - A resolution that is lower (half) of the Auto-resolution.
  • Auto high - A resolution that is higher (double) of the Auto-resolution.
  • Source - No simplification is performed. Note if the dissolve definition contain the same old areas twice in two different new areas source must be used.
Dissolve definition datasetDataset The definition of which new area each old area belongs to, i.e. a mapping between old area and new area identities. The key field should map to the keys in the geometry dataset. If no geometry dataset is provided, the geometries should be available in this dataset.
Geometries to dissolveDataset optional The dataset with area geometries to dissolve. May be none which means the geometries should be available in the dissolve definition dataset. The key field in this dataset must be linked to the key field in the dissolve definition dataset.

Intersects

>

Returns a table that maps between the key in dataset1 and the key in dataset2 for all objects that intersects. The field names in the returned table will be the same as for the key field in dataset1 and dataset2 respectively. If both datasets contain polygons, the relative overlap area compared to the areas of the original areas are returned in <Dataset1>_RelativeOverlap and <Dataset2>_RelativeOverlap.

The operation is symmetric.

ParameterTypeUseDescription
Dataset1Dataset A dataset with geometries to test for which intersects the geometries in the other dataset if specified, otherwise between objects in this dataset. When checking intersection between objects in a single dataset relations are never added from an object to itself.
Dataset2Dataset optional A dataset with geometries to test for which intersects the geometries in the other dataset.

IntersectsMost

Same as Intersects but only returns the relation to the area in Dataset2 each area in Dataset1 overlaps the most. This operation is useful when you want to build a hierarchy and relate smaller areas to larger areas but the smaller areas might overlap some borders of the larger ones.

ParameterTypeUseDescription
Dataset1Dataset A dataset with geometries to test for which intersects the geometries in the other dataset if specified, otherwise between objects in this dataset. When checking intersection between objects in a single dataset relations are never added from an object to itself.
Dataset2Dataset optional A dataset with geometries to test for which intersects the geometries in the other dataset.

IpLookup

Returns location information and point geometries for IP-addresses in a table. This is useful when you are analyzing access data to web services. The returned table contains the following fields:
  • <Address Table Ip Field> - same as the ip field that was looked up
  • <IP Table name>_Geomety - The point for the found item
  • CountryIso2 - The country code for the found item
  • <IP Table name>_Adm1Code - The code for the first order administrative area for the found item. Note that this code is not always compatible with the code returned by the location service.
  • <IP Table name>_City - The city for the found item

If you have many rows in your loaded data and the field with IP address is the same in many cases it improves performance to send only the distinct values to GeoAnalytics. Assuming you have a table called MyTable with a field called IP, then add this in the load script and send MyTable2 to GeoAnalytics:

MyTable2: LOAD distinct Ip resident MyTable;

IP geolocation is inherently imprecise. For many IP-addresses it is possible to pinpoint a city but for others only country can be resolved.

This product includes GeoLite2 data created by MaxMind, available from http://www.maxmind.com.

ParameterTypeUseDescription
IP Fieldstring optional The field with the IP-address to look up. Uses the key field of the dataset if not specified.
IP TableDataset A dataset with IP-addresses that will be looked up in the geocoder.

Load

Just loads the dataset, no operation applied. This makes it possible to load all the formats that GeoAnalytics supports.
ParameterTypeUseDescription
DatasetDataset Dataset to load.

NamedAreaLookup

Returns area geometries for each name in a table by looking them up in the location service. In the location service names for things like countries, administrative areas, airports, postal codes etc are available. The returned table contains the following fields:
  • <name table key field> - same as the key field for the name table
  • <name table name>_Geomety - the polygon for the found item
  • <nameField> - same as the input name field for all successful lookups, only available if the name field is not same as the key field in the name table
  • <name table name>_Name - the name from the location database
  • CountryIso2 - The country code for the found item
  • <name table name>_Adm1Code - The code for the first order administrative area for the found item
  • <name table name>_Adm2Code - The code for the second order administrative area for the found item
  • LocationDbType - The type code of the found item, see the Location Service Description
The names can be specified as described in the Location Service Description. In that case the type should be set to Any and no country specified. No rows are returned for names not found or when ambiguous.
ParameterTypeUseDescription
Name tableDataset A dataset with names that will be looked up in the location service.
Name fieldstring The field with names to look up.
Type of datastringdefault:Any Type of data that the names represents such as countries, administrative areas, postal codes etc. The default value means not restricted to a type. Restricting to a type potentially resolves ambiguities when same name is used for different entities.
Country code(s)stringdefault: Country code (2 or 3 letters) for the country to access. Several countries may be specified, separated by comma. The default value means not restricted to a country.

NamedPointLookup

Returns point geometries for each name in a table by looking them up in the location service. In the location service names for things like countries, administrative areas, airports, postal codes etc are available. The returned table contains the following fields:
  • <name table key field> - same as the key field for the name table
  • <name table name>_Geomety - the point for the found item
  • <nameField> - same as the input name field for all successful lookups, only available if the name field is not same as the key field in the name table
  • <name table name>_Name - the name from the location database
  • CountryIso2 - The country code for the found item
  • <name table name>_Adm1Code - The code for the first order administrative area for the found item
  • <name table name>_Adm2Code - The code for the second order administrative area for the found item
  • LocationDbType - The type code of the found item, see the Location Service Description
The names can be specified as described in the Location Service Description. In that case the type should be set to Any and no country specified. No rows are returned for names not found or when ambiguous.
ParameterTypeUseDescription
Name tableDataset A dataset with names that will be looked up in the location service.
Name fieldstring The field with names to look up.
Type of datastringdefault:Any Type of data that the names represents such as countries, administrative areas, postal codes etc. The default value means not restricted to a type. Restricting to a type potentially resolves ambiguities when same name is used for different entities.
Country code(s)stringdefault: Country code (2 or 3 letters) for the country to access. Several countries may be specified, separated by comma. The default value means not restricted to a country.

PointToAddressLookup

This operation is licensed separately and then only available in the cloud service.

Returns closest address for each point in the list. Note that no result is returned for a point if it is not close to an address. The returned table contains the following fields (values can be empty where data is not available or not applicable):

  • Key field - same as the key field for the name table
  • Address - The found address, formatted to the address standard of the country
  • Geometry - The point for the found item
  • HouseNumber - The house number for the found item
  • Street - The street for the found item
  • PostalCode - The postal code for the found item
  • City - The postal area name for the found item
  • Adm1Code - The code for the first order administrative area for the found item for countries where that is a part of the address
  • CountryIso2 - The country code for the found item
  • Distance - Distance in meters to the found address.
ParameterTypeUseDescription
Point TableDataset A dataset with points that will be looked up in the geocoder.
Preferred Languagestringdefault: The 2 letter language code of the preferred language in the reply. Will return names in the specified language where available. Note that most items only are available in the local language. Default is to return in the local language.
Service to use for lookupstringdefault:default Name of geocode service to use at the server.

Routes

Calculates routes including length and duration, between two locations in a table. Returns a table with key, length (in meters), duration (in seconds), status (OK or no route found) and a low resolution route line.

Note that the origin is the geometry column in the dataset. The destination column is specified in operation parameters since datasets only know of one geometry column.

If you use "bird" as transportation type it generates great circle arcs between origins and destinations.

ParameterTypeUseDescription
End PointsDataset A dataset with origins and destinations for the routes to calculate. The origins should be in the geometry of the dataset.
Criteriastringdefault:fastest Decides if fastest or shortest route is requested.
Transportationstringdefault:car The transportation mode, one of car, truck, bike, pedestrian or bird (which flies at 10m/s).
Destination Fieldstring The field in the dataset that specifies the destination. Note that the origin is the geometry field specified in the dataset.
Destination Geometry Typedefault:POINT Type of geometry in the Destination Field. Allowed values are Point, Location Named Point and Latitude and Longitude Point. In case of named points, the geometry is looked up in the location service and a column for the geometry is added.
Destination Location ID Suffixstring For advanced users. The specified string is appended to all IDs. This is a convenient way to specify more information to server based location services such as country code or type. The alternative is to append the extra data when loading the table into Qlik. With the following suffix all items are specified to be cities in Sweden:
:P*,SE
See Geometry Service Specification for more information on syntax to use.

Simplify

Simplifies the line and area geometries in the dataset. Returns a table with one field that is the key to the dataset to simplify and one with simplified geometries.

The degree of simplification is calculated automatically based on area, number of objects and size of objects. It is then possible to adjust that to a higher or lower resolution with the Resolution parameter.

Area simplification is done with an advanced algorithm that handles topologies and can remove gaps and join islands.

Line simplification is done with a breakpoint reduction algorithm.

Note that overlaps of polygons are removed. There will be no overlapping polygons in the output.

ParameterTypeUseDescription
Resolutionstringdefault:Auto The resulting dataset is simplified and the degree of simplification is controlled by this property. Available values are:
  • Auto - The operation calculates a resolution based on the data that often is OK.
  • Auto low - A resolution that is lower (half) of the Auto-resolution.
  • Auto high - A resolution that is higher (double) of the Auto-resolution.
Geometries to simplifyDataset The dataset with geometries to simplify.

SpatialIndex

Generates a spatial index for a dataset that is needed for the "Select Visible" feature in the Qlik GeoAnalytics extension. All generated index tables should be included (the ones starting with "IdevioSIndex"). Normally the operation parameters need not be changed from the default values.

Note that the "Select Visible" feature in the Qlik GeoAnalytics extension depends on the variable _IdevioSIndexFields that the load script sets. This means that if you generate the index in advance and load that into your app, make sure to set the variable also. Copy the generated line that looks something like this:

_IdevioSIndexFields='IdevioSIndexH0_04W0_06,IdevioSIndexH0_16W0_24,IdevioSIndexH0_64W0_96,IdevioSIndexH2_56W3_84,IdevioSIndexH10_24W15_36,IdevioSIndexH40_96W61_44'
ParameterTypeUseDescription
Side length of cellsrealdefault:0.04 The height (in degrees) of an individual spatial index cell at the most detailed level. An appropriate value is the side length of the map view that it is common to zoom in to.
Cell width-height-ratiorealdefault:1.5 The ratio CellWidth/CellHeight. Optimal is square cells but that varies by latitude. The formula for the optimal width height ratio is 1/cos(latitude), for example 1 at the equator, 1.15 at latitude +-30 deg and 2 at latitude +-60 deg.
Number of levelsdefault:6 The number of spatial index levels to be generated. Each level has level factor larger cell side than the level below.
Level factorrealdefault:4 The factor that the spatial index cell dimensions should be multiplied with for each level.
Script DatasetDataset The dataset with point geometries to generate a spatial index for.

TravelAreas

Calculates travel time iso areas. All locations within the returned area can be reached within a certain time or is closer than a certain distance along roads. Returns a table with id, travel area geometry, center point, cost, cost unit and status (OK or failed).

If you use "bird" as transportation type it generates geographically correct circles around the origins.

ParameterTypeUseDescription
OriginsDataset A dataset with origins and costs for the travel area calculations. The origins should be in the geometry of the dataset.
Cost Valuestringdefault: The cost at the border of the returned area. The cost can be either a length or a time, see cost unit below. An alternative that allows individual costs for each area is to specify the cost field instead.
Cost Fieldstringdefault: A field in the dataset that specifies the cost. This is only used if cost value is empty.
Cost unitstringdefault:seconds Should be one of seconds, minutes, hours, meters, yards, kilometers, miles. When seconds, the area reached within that time is calculated and when meters, the area with a travel distance shorter than specified is calculated.
Transportationstringdefault:car The transportation mode, one of car, truck, bike, pedestrian or bird (which flies at 10m/s).

Within

There is a relation between enclosed and enclosing if enclosed is completely inside the enclosing area. Returns a table which maps between the key in enclosed and the key in enclosing for all found relations. The field names in the returned table will be the same as for the key field in enclosed and enclosing datasets respectively.

Use within typically for finding which areas the data is in. For example to test GPS-position for which administrative area they are in. This is a kind of reverse geocoding.

ParameterTypeUseDescription
Dataset to test withing onDataset A dataset with geometries to test for which areas they are enclosed by.
Area datasetDataset A dataset with area geometries to test for which geometries they enclose.

Dataset

Data sources that can be used with operations in the Qlik GeoAnalytics connector.

Database

Access to tables in databases. Only available in GeoAnalytics Plus version or if enabled in local Qlik GeoAnalytics Enterprise Server installations.

Note that the JDBC driver for the particular database you access must be available to GeoAnalytics. See the Installation Instructions for GeoAnalytics Plus for further instructions.

ParameterTypeUseDescription
URL

Url in jdbc format.

Example for PostgreSQL:

jdbc:postgresql://myServer/myDatabase

Example for MySQL:

jdbc:mysql://myServer/myDatabase

Note that the JDBC driver for the particular database you access must be available to GeoAnalytics. See the Installation Instructions for GeoAnalytics Plus for further instructions.

Userdefault: User name.
Passworddefault: Password.
Tabledefault: The table to load. One of Table or SQL must be specified. This parameter is ignored if SQL is specified.
SQLdefault:

Optional SQL statement to execute. If specified then the Table parameter is ignored. Note that when reading geometries from a database they can in most databases be returned on WKT format. The following example formats a column called g in WKT format:

SELECT id, name, st_astext(geometry) as g FROM road WHERE roadclass=0
Key Fieldstringdefault: The name of the field that contains identities for each geometry. If you leave the field empty a key field will be generated.
Geometry Fieldstringdefault: Name of the geometry field if any. As an alternative to a geometry a column with names of well known names of points or areas may be specified, "Geometry Type" below. If point data is in two fields then specify name of latitude field comma name of longitude field. Geometries may be specified as WKT. Points are otherwise specified as "[longitude,latitude]". A line is an array of points like "[[longitude,latitude],[longitude,latitude],...]". A polygon is an array of closed lines or array of array of closed lines in case of multi-polygons.
Geometry Typedefault:WKT Type of geometry in the Geometry Field. Allowed values are WKT, Point, Line, Polygon, Location Named Point and Location Named Area. In case of named points or areas, the geometry is looked up in the location service and a column for the geometry is added. Also columns for country, type, administrative areas are added as in the Standard areas and Points dataset.
Location ID Suffixstring For advanced user. The specified string is appended to all IDs. This is a convenient way to specify more information to server based location services such as country code or type. The alternative is to append the extra data when loading the table into Qlik. With the following suffix all items are specified to be cities in Sweden:
:P*,SE
See Geometry Service Specification for more information on syntax to use.
CRSstringdefault:Auto CRS of the data to load. The data will be projected from this CRS to WGS84 (EPSG:4326) before being loaded into the app.

If set to Auto then EPSG:4326 (WGS84) is used.

File based geo dataset

Different kinds of geographical file formats like GeoJSON and Shape.
ParameterTypeUseDescription
URL The URL of the file containing the data. URLs with file-protocol are normally not allowed. In a local customer installation it may be allowed. When login is required for accessing the URL, user and password can be specified in the URL like this: http://username:password@hostname/ (note that passing login information like this is not possible in IE9).
Key Fieldstringdefault: The name of the field that contains identities for each geometry. If you leave the field empty a key field will be generated.
File Typestringdefault:Auto The type of file. Allowed values are:
  • Auto - Tries to detect the file type from the name of the file.
  • GeoJSON - The GeoJSON format as specified by geojson.org.
  • GML - For reading GML files or connecting to WFS services. Reads featureCollection files and makes one row of each featureMember element.
  • ESRI Shape file - A zip file with at least a shp and a dbf file.
  • ESRI Json - JSON as returned by ESRI ArcGIS Server (see ESRI doc of format). This makes it possible to connect to ArcGIS and import data from services it has published.
  • AutoCAD DXF file - For reading geometries from a DXF file. The following entity types are supported:
  • Points: POINT, TEXT, MTEXT
  • Lines: ARC, CIRCLE, LINE, POLYLINE, LWPOLYLINE, SPLINE, MLINE
Character encodingstringdefault: For some formats (like ESRI Shape) the character encoding is not defined in the format. This gives a way to provide this information. For most formats this property is ignored. Uses the Java character encodings available.
Expected Geometry Typestringdefault:Auto
  • Auto - Tries to detect type automatically.
  • Point - Looks for Points in the specified file.
  • Line - Looks for Lines in the specified file.
  • Polygon - Looks for Polygons in the specified file.
CRSstringdefault:Auto CRS of the data to load. The data will be projected from this CRS to WGS84 (EPSG:4326) before being loaded into the app.

If set to Auto or if empty it will try to parse it from the file. If no CRS is found in the file, then EPSG:4326 (WGS84) is used.

Loaded table

Data that is already loaded from other sources may be used as as a dataset. For large datasets it is more efficient to load data through the Qlik GeoAnalytics Connector than first loading them and then sending them to GeoAnalytics.
ParameterTypeUseDescription
Table Namestring The name of the loaded table that contains the data.
Table Fieldsstring The name of the fields from the table to use, separated by comma. The first field should be the key field and the second the location (unless Geometry Type is None). If latitude and longitude are in separate columns place them in second and third column. If the key and the location are in the same column, repeat it as both first and second column.
Geometry Typedefault:POINT Type of geometry in the Geometry Field. Allowed values are 'Point', 'Line', 'Polygon', 'Latitude and Longitude Point', 'Location Named Point', 'Location Named Area' and 'None'. In case of named points or areas, the geometry is looked up in the location service and a column for the geometry is added. Also columns for country, type, administrative areas are added as in the Standard areas and Points dataset.
Only load distinctdefault:NO When YES, an extra step is added that filters out distinct rows before sending data to GeoAnalytics. This might improve performance when you have many identical rows. One typically example is log files where you have rows containing IP addresses, typically many rows with same IP. Setting YES on this option speeds up the query a lot.
Location ID Suffixstring For advanced user. The specified string is appended to all IDs. This is a convenient way to specify more information to server based location services such as country code or type. The alternative is to append the extra data when loading the table into Qlik. With the following suffix all items are specified to be cities in Sweden:
:P*,SE
See Geometry Service Specification for more information on syntax to use.
CRSstringdefault:Auto CRS of the data to load. The data will be projected from this CRS to WGS84 (EPSG:4326) before being loaded into the app.

If set to Auto then EPSG:4326 (WGS84) is used.

Separated text file

Text files with table data, optionally with geometries. Instead of geometries also names of locations may be specified. All fields will be loaded as strings.
ParameterTypeUseDescription
URL The URL of the file containing the data. URLs with file-protocol are normally not allowed. In a local customer installation it may be allowed. When login is required for accessing the URL, user and password can be specified in the URL like this: http://username:password@hostname/ (note that passing login information like this is not possible in IE9).
Key Fieldstringdefault: The name of the field that contains identities for each geometry. If you leave the field empty a key field will be generated.
Geometry Fieldstringdefault: Name of the geometry field if any. As an alternative to a geometry a column with names of well known names of points or areas may be specified, "Geometry Type" below. If point data is in two fields then specify name of latitude field comma name of longitude field. Points are otherwise specified as "[longitude,latitude]". A line is an array of points like "[[longitude,latitude],[longitude,latitude],...]". A polygon is an array of closed lines or array of array of closed lines in case of multi-polygons.
Geometry Typedefault:POINT Type of geometry in the Geometry Field. Allowed values are Point, Line, Polygon, Location Named Point and Location Named Area. In case of named points or areas, the geometry is looked up in the location service and a column for the geometry is added. Also columns for country, type, administrative areas are added as in the Standard areas and Points dataset.
Location ID Suffixstring For advanced user. The specified string is appended to all IDs. This is a convenient way to specify more information to server based location services such as country code or type. The alternative is to append the extra data when loading the table into Qlik. With the following suffix all items are specified to be cities in Sweden:
:P*,SE
See Geometry Service Specification for more information on syntax to use.
Column namesstringdefault: The names of the columns separated by comma. If blank, the first row is supposed to contain the header.
Field Separatorstringdefault:TAB Character that separates fields. In addition to ordinary characters the key words TAB, NEWLINE, COMMA and SEMICOLON are allowed.
Record Separatorstringdefault:NEWLINE Character that separates lines. In addition to ordinary characters the key words TAB, NEWLINE, COMMA and SEMICOLON are allowed.
Character Encodingstringdefault:UTF-8 Character set for the file. Same values allowed as in Java.
String Quotesstringdefault:DOUBLEQUOTE Character that may be used for quoting strings. Field and record separators inside the quotes will not be parsed as such. The quotes will be removed in the imported data. In addition to ordinary characters the key words QUOTE("), DOUBLEQUOTE(") and SINGLEQUOTE(') are allowed.
CRSstringdefault:Auto CRS of the data to load. The data will be projected from this CRS to WGS84 (EPSG:4326) before being loaded into the app.

If set to Auto then EPSG:4326 (WGS84) is used.

Standard areas and points

Points and areas that are available in a Qlik GeoAnalytics Server location service.
ParameterTypeUseDescription
Geometry kinddefault:Area Chose to access Points or Areas.
Type of datastringdefault:Country Type of data that the names represents such as countries, administrative areas, postal codes etc.
Country code(s)stringdefault: Country code (2 or 3 letters) for the country to access. Several countries may be specified, separated by comma. The default value means not restricted to a country.
Name of Servicedefault:default Name of a location services that is available at the server.
Legal
Cookie and Privacy policy | Trademarks | Terms of Use | License Terms