Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Map - incorrectly rendering points by US state code

I am using QlikSense Desktop to render sales total by US State Code on the Map Chart using Point Layer.

Issue I am seeing is, many of the points are not shown on other parts of the world (instead of US).

Not sure why would point for some of states be shown outside of US.

Has anyone seen this issue?

Could it be because the kml file is for 500k but the qliksense map shows unit of measurement as 5000km?

If yes, is there any way to sync up the two?

Data I have-

==========

1. A spreadsheet that contains order qty, order total, order date, US state code.

2. KML file that originally contained US State Name, which I edited and changed to US State Code.

Data Load script-

==============

[cb_2017_us_state_500k/cb_2017_us_state_500k]:

LOAD

    [cb_2017_us_statecode_500k.xml.Name] as [STATE],

    [cb_2017_us_statecode_500k.xml.Point],

    [cb_2017_us_statecode_500k.xml.Area],

    [cb_2017_us_statecode_500k.xml.Line]

FROM [lib://OM_Sales_Geo/cb_2017_us_statecode_500k.xml]

(kml, Table is [cb_2017_us_state_500k/cb_2017_us_state_500k]);

[Sheet1]:

LOAD

    [ORDER#],

    Date(Date#([ORDERDATE], 'YYYYMMDD') ) AS [ORDERDATE],

    [STATE],

    [QTY],

    [TOTAL]

FROM [lib://OM_Sales_Geo/OM_SALES_WITH_STATE_CODE.xlsx]

(ooxml, embedded labels, table is Sheet1);

Map Setup:

=========

Layers: Point Layer

Dimension: STATE

Size & Shape: Sum(TOTAL)

Map output-

=========

10 Replies
agni_gold
Specialist III
Specialist III

There is no special document, but to know everything about maps, please go through help document.

If my solution works for you please mark the correct answer.