Dataset
CSV
Parameter | Type | Use | Description |
---|---|---|---|
url | string | default: None. |
The URL of the file containing the data. Only URLs with HTTPS or LIB protocols are allowed. You can use files from the data sources in the app's space using the following syntax: lib://DataFiles/<file name>. For example, lib://DataFiles/Offices.csv. You can also specify a space storing the files using the following syntax: lib://<space name>:DataFiles/<file name>. For example, lib://EuropeSales:DataFiles/Offices.csv. You can also specify a file from a Web Storage Provider Connector using the following syntax: lib://<Web Storage Provider>/<file name>. For example, lib://Dropbox/Offices.csv. |
keyField | string | default: None. | The name of the field that contains identities for each geometry. If you leave the field empty a key field will be generated. |
geometryField | string | default: None. | Name of the geometry field, if any. As an alternative to a geometry, a column with names of well-known points or areas may be specified as "Geometry Type" below. If point data is in two fields, then specify in the following format: name of latitude field comma name of longitude field. |
geometryType | string | default:POINT |
Type of geometry in the Geometry Field. Allowed values are:
|
suffix | string | default: None. |
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:
,SE:city
See the Geometry Service Specification for more information on what syntax to use.
|
header | string | default: None. | The names of the columns separated by a comma. If blank, the first row contains the header. |
fieldSeparator | string | default:TAB | The character that separates fields. In addition to ordinary characters, the key words TAB, NEWLINE, COMMA, and SEMICOLON are allowed. |
recordSeparator | string | default:NEWLINE | The character that separates lines. In addition to ordinary characters, the key words TAB, NEWLINE, COMMA, and SEMICOLON are allowed. |
encoding | string | default:UTF-8 | The character set for the file. The same values are allowed as in Java. |
stringQuotes | string | default: None. | The character that can 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. |
crs | string | default:Auto | CRS (Coordinate Reference System) 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. |
GEOFILE
Parameter | Type | Use | Description |
---|---|---|---|
url | string | default: None. |
The URL of the file containing the data. Only URLs with HTTPS or LIB protocols are allowed. You can use files from the data sources in the app's space using the following syntax: lib://DataFiles/<file name>. For example, lib://DataFiles/SalesGeographies.geojson. You can also specify a space storing the files using the following syntax: lib://<space name>:DataFiles/<file name>. For example, lib://EuropeSales:DataFiles/SalesGeographies.geojson. You can also specify a file from a Web Storage Provider Connector using the following syntax: lib://<Web Storage Provider>/<file name>. For example, lib://Dropbox/SalesGeographies.geojson. |
keyField | string | default: None. | The name of the field that contains identities for each geometry. If you leave the field empty a key field will be generated. |
type | string | default:Auto |
The type of file. Allowed values are:
|
encoding | string | default: None. | For some formats (like ESRI Shapefile) the character encoding is not defined in the format. This gives a way to provide this information. For most formats this property is ignored. |
expectedGeomType | string | default:Auto |
Only a single geometric type is loaded at a time. If there are multiple types in the data, use this property to set which type is loaded.
For formats that don't support multiple types, this parameter is ignored.
|
crs | string | default:Auto | Coordinate reference System (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. Note that setting this to a CRS overrides the information in the file and should only be done for files lacking such information or where it is known that the information is wrong. Files with data with several CRSs are not supported. |
INTABLE
Parameter | Type | Use | Description |
---|---|---|---|
keyField | string | optional | The name of a field that contains unique identities for each row. If not specified, a key column named _autoIndex_ will be added with unique values for each row. |
pointField | string | optional | Field containing point data in Qlik Sense point format, "[longitude, latitude]". WKT point data ("POINT(...)") is also supported. |
lineField | string | optional | Field containing line data in Qlik Sense line format: "[[longitude,latitude],[longitude,latitude],...]". WKT line data ("LINESTRING(...)" or "MULTILINESTRING(...)") is also supported. |
polygonField | string | optional | Field containing line data in Sense polygon format, i.e., an array of closed lines or array of array of closed lines in the case of multi-polygons. WKT polygon data ("POLYGON(...)" or "MULTIPOLYGON(...)") is also supported. |
latitudeField | string | optional | Field containing latitude values. |
longitudeField | string | optional | Field containing longitude values. |
namedPointField | string | optional | Field containing names of geographic features that are looked up in the location database. The names will be represented with points. |
namedAreaField | string | optional | Field containing names of geographic features that are looked up in the location database. The names will be represented with polygons. Not all names in the location database have associated polygons. |
crs | string | default:Auto | CRS (Coordinate Reference System) 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. |
LOCATIONSERVICE
The fields in tables loaded from the location service are:
- LocationDbId - Unique id for each entity.
- LocationPoint/LocationArea - The geometry of the entity.
- CountryIso2 - The two-letter country code.
- Adm1Code - Nation-specific code of first order administrative area.
- Adm2Code - Nation-specific code of second order administrative area.
- LocationDbType - See the Geometry Service Specification for more info on the types.
This example loads the states in the US:
Parameter | Type | Use | Description |
---|---|---|---|
geometry | string | default:Area | Choose to access Points or Areas. |
type | string | default:Country |
Type of data that the names represents such as countries, administrative areas, postal codes etc.
The following simplified type names can be used (case insensitive) in the native types in the location database:
|
country | string | default: None. | Country code (2 or 3 letters) for the country to access. Several countries may be specified, separated by commas. The default value means not restricted to a country. |