Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
maheshankala
Explorer
Explorer

Qlik Sense Maps

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

 

Labels (3)
1 Solution

Accepted Solutions
vvira1316
Specialist II
Specialist II

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

cs.PNG

 

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]);

 

View solution in original post

2 Replies
vvira1316
Specialist II
Specialist II

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

cs.PNG

 

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]);

 

View solution in original post

vvira1316
Specialist II
Specialist II

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]);

cs.PNG

 

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)