How to map a county point layer successfully ?

[vsabbise]

Hi All,

I am trying to plot County level data on a map (Qlik Sense Desktop) but unfortunately because of duplicate county names per state I am not able to do it successfully. This is resulting in plotting of a county pertaining to one state in a other State.

For Example:  County Named 'Lee County' exists in both Texas & Florida. 

But the correct state that is corresponding to the county in my data is for Texas only. However Qlik Sense puts Lee County in Florida.

I need to plot County level data across the United States not limiting to one state. Can some one let me know how to handle this scenario ?

As you can see in the image. I wanted to plot Texas counties on the map but  some American states share same county names causing the issue.  1) How can I restrict the counties to Texas alone ?  2) How can I do this for all the states in one map ?

Texas County Map

[Patrik_Lundblad]

Hi Ale,

Could you give a data example?

Regards,

Patrik.

[BU]

Of Course.

I need to Show data relative for 2 countries: Italy & Malta (img 1) and i've tryed to insert in the field "Country" a multiple string (img 2) but seems doesn't work. I'v found a workaround creating 2 different layers: 1 for Italy and 1 for Malta.

if someone have a better solution, I'll be grateful.

Thx a lot

Ale

[Patrik_Lundblad]

Doesn't seem like we support a list/array of countries as manual input. 

What you would have to do is to create an extra column (or table) in your data set and map each region to country. Then in the Country input box you would add the Country field and we would use that to find the region in the correct country. 

Regards,

Patrik.

[BU]

It works!! Thx Patrik

[tyt5177]

This is a good post. 
To add in 2025, since Qlik keeps changing things.

Administrative area Lv 1 - State

Administrative area Lv 2 - County

Administrative area Lv 3 - City

I needed Counties in Iowa, so I had to use multiple: