Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
rothtd
Creator III
Creator III

Area layer confused on multiple same name counties

In this example you will see that my current selections are associated with two counties, which happen to have the same name (Benton, Iowa; Benton, MN). GeoAnalytics is shading the area in Arkansas corresponding to Benton County, Arkansas. Why is Qlik getting confused here? Do I need to adjust my expression, and if so, how?

Thanks in advance!

2017-08-24_14-23-07.png

2017-08-24_14-28-33.png

1 Solution

Accepted Solutions
rothtd
Creator III
Creator III
Author

For the benefit of others...

You'll notice my dimension was 'County', which is the field that included duplicate values. Using the load script I created a field with County-State concatenated together so it would be more specific. Using this field as the dimension resolved the issue.

2017-08-24_14-46-23.png

View solution in original post

1 Reply
rothtd
Creator III
Creator III
Author

For the benefit of others...

You'll notice my dimension was 'County', which is the field that included duplicate values. Using the load script I created a field with County-State concatenated together so it would be more specific. Using this field as the dimension resolved the issue.

2017-08-24_14-46-23.png