Qlik Community

Qlik Sense Documents

Documents about Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS

Creating a Polygon (choropleth) Map

Employee
Employee

Creating a Polygon (choropleth) Map

There are currently two types of maps that are supported with Qlik Sense:

This video shows you how to create a Polygon (choropleth) map using KML.

Note: It may be necessary to view this video from the YouTube site, in order to access the full screen and resolution controls. Simply click the YouTube logo found in the bottom right of the player. Controls in the embedded player vary per browser.

There are some sample .kml files you can use as well.

Note: It may be necessary to view this video from the YouTube site, in order to access the full screen and resolution controls. Simply click the YouTube logo found in the bottom right of the player. Controls in the embedded player vary per browser.

Attachments
Comments
Contributor III
Contributor III

Hello, I am having issues with utilizing a polygon map in Qlik. If experts here are able to assist, could you please comment at: Mapping KML - fail. Thank you.

0 Likes
Partner
Partner

Hi Mike

I am trying to create this polygon map using QlikSense June 2017 version and am finding that when I try to rename the field world.name to CountryISOCode QlikSense won't allow me to?

The error message is: "The field name must be unique. This field already exists in table: SalesData$"

This is a very strange error because of course it should be possible to join any two tables by setting field names to be the same in each table?

Do you have any idea what I'm doing wrong?

Thanks

Richard

0 Likes
Employee
Employee

Hi Richard - you are not doing anything wrong - unfortunately - that is an issue with the visual data prep, I have reported it -  technically since we introduced visual data prep - you should be able to associate the columns without having to manually rename the fields. Have you tried the auto-associate wizard option in the visual data prep interface - it should recognize the like data and associate those columns.

Also in the latest release we recognize some basic location data - Country, City names so you may not need to add a KML file. I am going to remake these video now and show this process with the new release.

Partner
Partner

Hi Mike. Many thanks for your reply. We have tried the auto-associate wizard option but it just says that no associations are found. We've even tried dragging the world kml table in association viewer mode and dropping it onto the other table, but we see a red circle instead of a green one.

However, since you suggest it I will go back to that and try again and let you know if anything different happens....

Will also try without the KML file at all, which would be cool

Thanks again and look forward to the new video.

Cheers

Richard

0 Likes
Partner
Partner

Hi Again Mike

To clarify.

Using the magic wand icon (Associate data according to recommendations" doesn't work. There are no recommendations.

But dropping one table onto the other to force association, after displaying a red circle, then presents the "Associate tables" pop up window, allowing me to select a field from each of the two tables.

When I do this, the Association Name defaults to CountryISOCode (which is from the 2nd table, the one on the right of the window) but I don't have the option to "Associate". The button is disabled?

If I rename the Association (e.g. from CountryISOCode to something like "JOIN_COUNTRY" then the button becomes enabled and I can force the association.

So thanks for the tip


0 Likes
Partner
Partner

Hi Michael

Final point to note.

I did what you suggested and tried to create the map without the KML file.

It works

The only issue is that, of course, you only see a map covering countries for which there is data in the Getting Start xls data.

So I get a map of North America.

But hey, the map definitely works without the KML file.

Thanks again

Richard

0 Likes
Employee
Employee

Hi Richard awesome - I just saw your comment - I just re-created and updated the video here: https://community.qlik.com/docs/DOC-6941

I will be removing this particular community document that we are conversing in now, as it is older and no longer valid. Thanks for reaching out.

Note you can turn on the background to see the other countries when using the polygon map - reach out to me in a separate discussion thread is you need further assistance. You can tag me by typing @michael_tara and select mto from the pop up:

Take care

Mike

Specialist
Specialist

Hello Michael.

can you help me in this?

Making State boundary differ from existing state boundary

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-10-29 03:55 PM
Updated by: