Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
Qlik GeoAnalytics 'Dissolve Function' not working with US counties
Article Number: 000053618 | Last Modified: 2018/07/22Description
The Qlik GeoAnalytics 'Dissolve Function' does not dissolve correctly when working with United Sates (US) Counties.
Environments:
Qlik GeoAnalytics April 2018 (5.11.1)
Environments:
Qlik GeoAnalytics April 2018 (5.11.1)
Resolution
US Counties are bit tricky since the county names are ambiguous. We suggest create a new field at load to make a unique so the match will work.
county & ',' & state & ',US:AADM2' as county_key
The country code and the location code have been added to help the lookup service further.
More info on how lookups works: https://bi.idevio.com/wp-content/qlik/qliksense/releases/IdevioMapsForQlikSense-5.12.1/geometry_service.html
Source:
https://community.qlik.com/thread/307538
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us