We've finally got some data to utilize the map visualization in qlik. One column is pretty much our states. But for some odd reason, when I am looking at MA (Massachusetts) it is being plotted to a country in Africa. Obviously there needs to be some clean up but this behavior seemed a bit off as 80% of the states are being mapped properly to its respective state. What is the best way of handling and cleaning this data? Is it better to get latitude and longitude data instead?
Thanks.