Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Strange thing regarding Map Chart

Hi everyone,

I downloaded US.zip from GeoNames, and tried to create a map chart based on zip code. This is my script:

111.PNG

222.PNG

But the map shows like this:

333.PNG

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:

4444.PNG

Any ideas what the problem is?

1 Solution

Accepted Solutions
Digvijay_Singh

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

Capture.PNG

View solution in original post

10 Replies
Digvijay_Singh

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.

Capture.PNG

Digvijay_Singh

script used as below -

LOAD

    @1,

    @2,

    @3,

    @4,

    @5,

    @6,

    @7,

    @8,

    @9,

    @10,

    @11,

    @12,

    @13,

    @14,

    @15,

    @16,

    @17,

    @18,

    @19,

    GeoMakePoint(@5,@6) as Location

FROM [lib://data/US.txt]

(txt, utf8, no labels, delimiter is '\t', msq);

wanyunyang
Creator III
Creator III
Author

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.

555.PNG

wanyunyang
Creator III
Creator III
Author

This is the US.txt I'm using.

Digvijay_Singh

Looks like mine one is different, its size is 294 MB after extract. But I took it from the same location -

Capture2.PNGCapture1.PNG

wanyunyang
Creator III
Creator III
Author

Could you kindly share me the file you are using?

Digvijay_Singh

Here is the one, but something is wrong, when I tried next time, I see what you have attached. Strange!

Digvijay_Singh

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

Capture.PNG

wanyunyang
Creator III
Creator III
Author

So it's just because it exceeds the maximum number, nothing wrong with the data or what I'm doing, right?