Can we use any extension to plot different city and state without using latitude and longitude

[Tanviseth26]

As per the US country data there are multiple states that has same city names, such as mentioned below. Is there any extension or any other way to plot the city and state only these two columns in map without using latitude and longitude?

Country	City	State	Population	Zip Code
USA	Springfield	Missouri	165378	49015
USA	Springfield	Illinois	116809	62629
USA	Rochester	New York	209983	14604
USA	Rochester	Minnesota	111402	55905
USA	Riverside	California	319504	92503
USA	Yonkers	New York	200667	10703
USA	Worcester	Massachusetts	183016	01655

[Patric_Nordstrom · Accepted solution]

Hi,
Yes, location lookup is available both in QS native mapchart (as of april 2018) and in Qlik GeoAnalytics.
Check the location tab and enter City, Country and State info.
Don't forget to make a id dimension, City as dimension is not enough, in your table you only have 5 unique values for 7 cities.

Thanks,
Patric

[Tanviseth26]

Hi Patric,

I want to plot the unique combination of city and state. It would be great if you can provide any sample or example.

Also as you have mentioned to use id as dimension, it would be great if you can specify what you meant by id.

[Patric_Nordstrom · Accepted solution]

Hi,

Ok, a quick way to make a unique key is to concatenate the city and state field: city & ',' & state as city_key. Use city_key as the as the dimension for the point layer. After that, go and set the country in the location tab. 

The dimension controls the number of items in the layer, with 5 unique city names you get 5 bubbles. Which won't work cause there are 7 cities, two with same name. Adding state info will make the name unique. See my example.

Thanks,

Patric

[Tanviseth26]

Thank you Patric. It worked and it was really helpful.