Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

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
Honored Contributor III

Re: Strange thing regarding Map Chart

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

10 Replies
Digvijay_Singh
Honored Contributor III

Re: Strange thing regarding Map Chart

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
Honored Contributor III

Re: Strange thing regarding Map Chart

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
Contributor

Re: Strange thing regarding Map Chart

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
Contributor

Re: Strange thing regarding Map Chart

This is the US.txt I'm using.

Digvijay_Singh
Honored Contributor III

Re: Strange thing regarding Map Chart

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
Contributor

Re: Strange thing regarding Map Chart

Could you kindly share me the file you are using?

Digvijay_Singh
Honored Contributor III

Re: Strange thing regarding Map Chart

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

Digvijay_Singh
Honored Contributor III

Re: Strange thing regarding Map Chart

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
Contributor

Re: Strange thing regarding Map Chart

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

Community Browser