I am trying to use the Map chart type to plot a concentration of spending across different states in United States. I have City, State & Country & Spend Amt information. I am primarily interested in just using the City and Spend fields. However, when I drag the map chart type onto my sheet, I keep getting the "No hits" error when I try to add a dimension.
From my understanding, it is happening because Qlik Sense does not recognize the fields as a geo location. However, I have gone into the Data Manager and manually changed each of the fields to a geolocation. It still does not work. Any way to get around this?
