Qlik Sense Maps

[maheshankala]

Hi All,

How to create UK regions-  area map in qlik sense, If I load the below regions into map , not showing all regions.

Can any one please suggest how to make Area Map in Qlik sense with below regions . Thanks in advance. 

Region
East Midlands
East of England
London
National
North East
North West
Northern Ireland
Scotland
South Central
South East Coast
South West
Wales
West Midlands
Yorkshire & the Humber

[vvira1316 · Accepted solution]

I'm not sure if there is an easy or direct way then how I have been able to do it as mentioned below.

I had used following using the reqion name to view geo area

https://nominatim.openstreetmap.org/search.php?q=East+Midlands%2C+UK&polygon_geojson=1&viewbox=

and following to get polygon coordinates

https://nominatim.openstreetmap.org/search.php?q=East+Midlands%2C+UK&polygon_geojson=1&format=json
https://nominatim.openstreetmap.org/search.php?q=East+of+England%2C+UK&polygon_geojson=1&format=json

From the saved JSON file I had to remove the Beginning and Ending Square Brackets to do the conversion to KML

Following sites can be used for conversion
https://mygeodata.cloud/converter/json-to-kml
https://geoconverter.hsr.ch/

I had to edit and merge the individual KML files to create a single KML for easier loading in Qlik Sense. Please refer to following text and files for reference.

<?xml version="1.0" encoding="utf-8" ?>
<kml xmlns="http://www.opengis.net/kml/2.2">
<Document id="root_doc">
<Folder>
<name>RegionName</name>
<Placemark>
<name>East of England</name>

<Style><LineStyle><color>ff0000ff</color></LineStyle><PolyStyle><fill>0</fill></PolyStyle></Style>
<Polygon><outerBoundaryIs><LinearRing><coordinates> (Multiple Coordinate here that are removed here in example but you can refer in file)

</coordinates></LinearRing></outerBoundaryIs></Polygon>

</Placemark>

The above italic section you can repeat for each region.

NoConcatenate
[SalesData]:
LOAD
Region1,
RegionName,
SalesCountry,
SalesCountryCode2,
SalesCountryCode3,
Sales//,
// Latitude,
// Longitude,
// AreaCoordinates
FROM [lib://AttachedFiles/UKData.xlsx]
(ooxml, embedded labels, table is Sheet3);

LOAD
UKRegion.Name as RegionName,
// UKRegion.Point,
UKRegion.Area as Area//,
// UKRegion.Line
FROM [lib://AttachedFiles/UKRegion.kml]
(kml, Table is [UKRegion/RegionName]);

[vvira1316]

Hi,

Here is another site that can provide better mapping 

https://borders.ukdataservice.ac.uk/easy_download.html

I had to edit the KML files.

LOAD
infuse_rgn_2011.Name as RegionName,
// infuse_rgn_2011.Point,
infuse_rgn_2011.Area as Area//,
// infuse_rgn_2011.Line
FROM [lib://AttachedFiles/infuse_rgn_2011.kml]
(kml, Table is [infuse_rgn_2011/sql_statement]);
Concatenate
LOAD
wales_ol_2011.Name as RegionName,
wales_ol_2011.Area as Area
FROM [lib://AttachedFiles/wales_ol_2011.kml]
(kml, Table is [wales_ol_2011/sql_statement]);
Concatenate
LOAD
scotland_ol_2001_mod.Name as RegionName,
scotland_ol_2001_mod.Area as Area
FROM [lib://AttachedFiles/scotland_ol_2001_mod.kml]
(kml, Table is [scotland_ol_2001_mod/sql_statement]);

The Northern Ireland data points in a single node is too long. Qlik is unable to load and will receive following error message

The following error occurred:

xmlSAX2Characters: huge text node On line number: 16. SystemID: (null)