I will get you started, first, I took a couple of cities from your list: Worcester and Milford, then I gots its coordinates from Google Map, the solution file (attached) perform an INLINE load for these to cities, the columns on this inline load are: City, Patients, Latitude, Longitude, then within the same INLINE load a created a new colum using QlikSense's function GeoMakePoint, I named this table: Data_Sample. Once I loaded this data, on the User Interface I dragged a map component, and because the Data_Sample contains a GeoMakePoint, it allowed me to define the map.
Please see the attachment, and select the MAP sheet.
NOTE: I used this solution to help somebody else, that's why you will find other stuff in the application.
NOTE 2: You do not need a KML file at all.
Hope this helps,
Table Colors.qvf 208.0 K