Map Chart

[wanyunyang]

Hi guys,

I got US-POST&LAT&LNG.txt online (GeoNames, US.zip), with zip code, latitude and longitude information. My script in data load editor is like:

But the map shows like this:

Which is confusing, many dots in the US are not showing. Like this dot in CA, which is only shown with the filter:

Any ideas?

Thanks in advance!

[rupamjyotidas]

I would suggest using the ZipCode &'-'& CountryName as your dimension to allow Qlik to differentiate Zipcodes among different countries

[wanyunyang]

Hi Rupam,

Thanks for help!

I modified my script with the highlighted line:

Then I used Zip field as my point layer, the map shows like this:

Any ideas?

[rupamjyotidas]

@2&','@6 as ZIP, this should help you. Also put sorting as 'None'.

This thread would you.

Re: Is there a way to pre-scrub location information for correctness?