Discussion board where members can get started with Qlik Sense.
I downloaded US.zip from GeoNames, and tried to create a map chart based on zip code. This is my script:
But the map shows like this:
Which doesn't make sense, because all dots should be in US. And many dots are not shown. Like in CA, there is a dot with zip code 90001. It will be shown only with the filter:
Any ideas what the problem is?
Go to Solution.
I think this is the main issue with your data -
As per documentation the maximum number of values in a point layer map is 3333.
When I clicked on TN state, I could see all zips properly shown in the map
Which field you have used as zip code. I see the first field(@1) with 8-9 digit code in downloaded data from the same location. Here is what I see if I consider that field as zip code.
script used as below -
GeoMakePoint(@5,@6) as Location
(txt, utf8, no labels, delimiter is '\t', msq);
Which file are you using from GeoNames? I'm using the US.txt file in US.zip from GeoNames
It shows like this in data load editor: only 12 columns, I'm using @2 as zip code.
This is the US.txt I'm using.
Looks like mine one is different, its size is 294 MB after extract. But I took it from the same location -
Could you kindly share me the file you are using?
Here is the one, but something is wrong, when I tried next time, I see what you have attached. Strange!
So it's just because it exceeds the maximum number, nothing wrong with the data or what I'm doing, right?