Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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-
=========
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.