Area layer - States with same names not recognized
I'm facing an issue when using the map visual with area layer for two particular states ('provinces') in Belgium and The Netherlands. They both have a state called 'Limburg' which is not shown on the map when the two countries are in the selection together, but is shown otherwise. (In Qlik Sense September release)
I've built an excel file with a listing of all cities (+ postal codes) in each state for certain countries in Europe. A line looks like this:
I've declared the location with the field of the state, and added the field with the country:
This approach works fine when having the two countries selected separately:
When selecting both Belgium and the Netherlands, all states in both countries are recognized, except for the both states called Limburg:
Does anybody has any idea how to overcome this issue with the same data set? As it is working for the countries separately, and a field with the country is present, I don't really get why this is not working.