I have been using geoanalytics and have been trying to create my own areas based on dissolve function.
My dataset looks as follows:
This data is limited to Illinois only, and has regions running from 1 to 5
I use the dissolve function as follows:
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.
I am wondering what i might be doing wrong here, and if anyone is able to help would be greatly appreciated.
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!