Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

Map Chart

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:

111.PNG

But the map shows like this:

222.PNG

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

333.PNG

Any ideas?

Thanks in advance!

3 Replies
rupamjyotidas
Valued Contributor

Re: Map Chart

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

wanyunyang
Contributor

Re: Map Chart

Hi Rupam,

Thanks for help!

I modified my script with the highlighted line:

111.PNG

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

222.PNG

Any ideas?

rupamjyotidas
Valued Contributor

Re: Map Chart

@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?

Community Browser