Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus.Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Geoanalytics dissolve using county

Hi,

I have been using geoanalytics and have been trying to create my own areas based on dissolve function.

My dataset looks as follows:

Screen Shot 2018-07-11 at 13.45.31.png

This data is limited to Illinois only, and has regions running from 1 to 5

I use the dissolve function as follows:

Screen Shot 2018-07-11 at 13.45.52.png

This processes fine, and it pulls 5 records, which ties up with the number of regions. However when plotting within Qlik, there appears to be only 1 region, and placed in Egypt, no where near Illinois US.

Screen Shot 2018-07-11 at 13.46.05.png

I am wondering what i might be doing wrong here, and if anyone is able to help would be greatly appreciated.

Thanks,

Rob

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: Geoanalytics dissolve using county

Hi Robert,

US Counties are bit tricky since the county names are ambigous.

I suggest create a new field at load to make a unique so the match will work.

county & ',' & state & ',US:AADM2' as county_key

I added the country code and the location code 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_serv...

Thanks,

Patric

View solution in original post

5 Replies
Highlighted
Employee
Employee

Re: Geoanalytics dissolve using county

Try specifying United States as Country under Location Options in your area layer

Highlighted
Partner
Partner

Re: Geoanalytics dissolve using county

Hi Lisa,

Thank you for the suggestion.

I have tried to change the location area to US, which changes the perspective, however the regions should be based in Illinois only.

Screen Shot 2018-07-17 at 08.59.38.png

Thanks,

Rob

Highlighted
Employee
Employee

Re: Geoanalytics dissolve using county

Hi Robert,

US Counties are bit tricky since the county names are ambigous.

I suggest create a new field at load to make a unique so the match will work.

county & ',' & state & ',US:AADM2' as county_key

I added the country code and the location code 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_serv...

Thanks,

Patric

View solution in original post

Highlighted
Partner
Partner

Re: Geoanalytics dissolve using county

Thank you Patric!

That worked perfectly, i added the unique field county_key, and remapped my dissolve, and now this works.

Thank you again.

Highlighted
Contributor III
Contributor III

Re: Geoanalytics dissolve using county

Patric:
This was a very helpful hint. Appending ':AADM2' to 'US' solved a problem where U.S. counties which shared the name with the state (e.g. New York, NY, US or Idaho, ID, US) was displaying the state rather than the county. This saved me a lot of time converting state and county KMLs. Much appreciated!