City names are ambiguous, so please help the lookup by adding more information
=city & ',' & state_abbr & ',US'
Here's a link to the tech doc:
There's a nice video also about this topic:
Thank you for the quick response. I tested this again, but this time using a City,State,Country key as you suggested. I tried this in multiple formats, but in every case the map failed to plot any values when using that field as the point layer, even though I had labeled it as GeoData and tagged it as City (which is the only option other than Country). I hope I was clear in that, this is just the base 3.1 SR5 Sense installation and I'm using the standard Map visualization. We have not yet invested in GeoAnalytics which represents the Qlik acquisition of Idevio, which seems to be what is referenced in the video you linked to in your response. So, am I just getting ahead of myself in trying to accomplish this?
Miss-matches will happen, city names are ambiguous and can be spelled in different ways.
QGA includes alias for many cities but not all them.
1. Correct the city name at the source (not always possible)
2. Layer properties->Location Options->Manual Remap (if just a few errors)
3. Create a translation table that holds the different spellings.
Yes, fyi QGA also recognizes country, state and county codes for many administrative boundaries.
For more information check the technical documentation. Location Services
In US, the state abbreviation is the code and for counties the three digit FIPS code.