Cities not mapping correctly in Qliksense Map

[imhappieee]

Hi 

We are trying to create a Map with the global data (COuntry, State, CIties) that we have  and are mapping with Covid data with Country and states to present the Employee count in respective city  and would like to see how effected is that city/State with Virus  on(effected,recovered,death count ) basis.

Issues are

how to connect this data 

how to map them on Geo as we see the cities are getting dissipated (like Georgia in US as per below screen shot)

how to get drill down from country to state level to see both values at chart level(Employee count and affected count))

please note we dont have Lat and Lon or Zip code for the above data except state names and ISO3 code for country

Any help would be highly Appreciated, Thanks in Advance

Anand

[venkat_meruva]

You can use a drill down to move from country to state and city and for the location not matching correctly see the following article

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Map-How-to-Correct-Location-Could...