Qlik Community

Qlik GeoAnalytics Documents

Documents related to Qlik GeoAnalytics.

Qlik GeoAnalytics Coverage

Employee
Employee

Qlik GeoAnalytics Coverage

The current coverage of the built in location database in Qlik GeoAnalytics. The zip file contains a overview description and table with content per country.

Labels (1)
Attachments
Comments
roelemanskiblue
New Contributor

Patric, could you please provide me current area-coverage information for The Netherlands? Which administrative areas are covered and are there examples of the names used? I have searched everywhere but this is not to be found.

Employee
Employee

‌HI Roel,

You can use the Load operator in the GeoAnalytics to retrieve all info.

Choose standard db, type adm1 and set country code NL.

Thanks,

Patric

roelemanskiblue
New Contributor

YES! Thanks, Patric! Finally I know how to determine what areas are being provided and which ones we should create ourselves.

Would be even better to be notified if an update is added for The Netherlands, but hey now I'm able to check myself from time to time.

kevinpintokpa
Contributor II

Hi Patric,

Can you provide an example of how to do this in QlikView?  Or Qlik Sense?

Employee
Employee

Hi,

Check out examples for all operations including Load at

Guides & Examples « bi.idevio.com

The examples are made with Qlik Sense the load script code will work in QlikView too.

Thanks,

Patric

roelemanskiblue
New Contributor

I just checked the coverage of The Netherlands again using the method above.

Unfortunattely only the levels Adm1 and Postcode are available (areas).

Must say that i'm kind of disappointed by the slow rate this is being updated.

When will other levels be updated for The Netherlands?

Employee
Employee

Hi Roel,

There will soon be new version of the db, which will include among other things adm2 for Australia and the Netherlands.

Please note that it is easy to load your own areas into Qlik Sense, see this guide:

Loading Esri shapefiles in Qlik GeoAnalytics

Thanks,

Patric

ersgersg
New Contributor III

Hi

What about UK Post Code ?  using list available : https://www.doogal.co.uk/PostcodeDownloads.php

Postcode :

 

HP5 3RP
BR1 1AA
BR1 1AB

I manage to get GeoAnalytics to understand the first 3 letters doing : left(Postcode,3)& ',UK'&':XPC'

but if i want to go to 6 letters doing : Left(Postcode,3)&right(Postcode,3)&',UK:XPC'

it doesn´t find it.  are the 6 letters UK post code supported ?

Thanks

Employee
Employee

Hi,

For UK, area, district and sector are supported as areas.

Example NR, NR12 and NR12 7

For higher accuracy down to unit level I recommend the add on Qlik Geocoding.

https://bi.idevio.com/products/qlik-geocoding

Thanks,

Patric

barryflash2727
Visitor

I manage to get GeoAnalytics to understand the first 3 letters doing : left(Postcode,3)& ',UK'&':XPC'

but if i want to go to 6 letters doing : Left(Postcode,3)&right(Postcode,3)&',UK:XPC'

it doesn´t find it.  are the 6 letters UK post code supported ?

Click Here | Homepage | Webpage |

Version history
Revision #:
1 of 1
Last update:
‎06-14-2017 02:11 AM
Updated by:
Employee