Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Qliksense Polygon Map UK

Hi,

I have a dataset that included UK Post Codes, Longitude / Latitude Codes and Unitary Authority codes.  I need to display this data on a polygon map rather than point map based on Post Codes.

I have imported the UK KML file into my app - but unsure on how this joins to my dataset.

Ideally I need to group my information by Unitary Authority areas :

ua_areas.PNG

Does anyone have any pointers or example app of UK polygon maps?

Many thanks for any help,

TJM

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Hi tjm,

basically, you need to find the common field between the KLM file and your data set. If the KLM file contains Unitary Authority Areas, then your own data needs to be mapped to the same codes or names. You might have to load a map that associates the Post Codes with the Unitary Authority Areas.

Once the association is created, the rest is fairly straightforward - you simple create an area map.

cheers,

Oleg Troyansky

Upgrade your Qlik development skills with my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense

Oleg Troyansky

Masters Summit for Qlik is going virtual! Nov 18th - I'll teach Advanced Set Analysis and AGGR

View solution in original post

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Hi tjm,

basically, you need to find the common field between the KLM file and your data set. If the KLM file contains Unitary Authority Areas, then your own data needs to be mapped to the same codes or names. You might have to load a map that associates the Post Codes with the Unitary Authority Areas.

Once the association is created, the rest is fairly straightforward - you simple create an area map.

cheers,

Oleg Troyansky

Upgrade your Qlik development skills with my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense

Oleg Troyansky

Masters Summit for Qlik is going virtual! Nov 18th - I'll teach Advanced Set Analysis and AGGR

View solution in original post

Highlighted
Not applicable

Thanks!!!

One last thing,  My Map is showing the whole of the UK when I only have data relating to a small area.  Is it possible to limit how much of the map is displayed or can it zoom to the correct areas?

Highlighted
MVP & Luminary
MVP & Luminary

Hmm... usually the map only shows the available ("possible") points and areas. Maybe you have some data for the "borderline" areas - that would cause the whole map to be displayed. I'm not sure what else could be wrong.

Oleg Troyansky

Masters Summit for Qlik is going virtual! Nov 18th - I'll teach Advanced Set Analysis and AGGR

Highlighted
Not applicable

Hi,

Could it be that I'm bringing the whole of the UK KML codes as a joined lookup? Whereas my dataset is only for a few areas

Highlighted
MVP & Luminary
MVP & Luminary

Maybe... in this case, use LEFT KEEP or WHERE EXISTS() in the process of loading the KML data, to reduce the data only to the available areas.

Oleg Troyansky

Masters Summit for Qlik is going virtual! Nov 18th - I'll teach Advanced Set Analysis and AGGR

Highlighted
Partner
Partner

Hi Tim

You should be able to untick a check box against the dimension of the Map object so that nulls are not included.

Then if you don't have data for locations in the KML file they should be ignored and the map will automatically zoom in to just cover those locations with data (whatever your measure is).

You also have to have auto-zoom ticked for that, but it is by default.

Hope that helps?

Please confirm if it does by marking this response as being the correct answer or helpful.

Thanks

Richard