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-
=========
make this setting
make sure , your data loaded for state code must be in same digits , which are present in kml file .
Also have you mentioned 'US' as country in point layer ?
Thanks Agnivesh.
When you say 'data loaded for state code must be in same digits , which are present in kml file' are you referring to the the state code itself?
The spread sheet that I am using only has - order qty, order total, order date, US state code.
And I can see there is an association between the STATE code loaded form spreadsheet to the KML file STATE code.
Both the spreadsheet and kml has two letter US state codes (eg: NY, NJ, CA, FL etc).
Also I do not see an option for selecting US as country in point layer.
Can you please expand on this?
In location option, you have to make the scope of location as custom, not Auto, there you will get the option to select which type of data you have to select the appropriate option and in-country section put 'US' (in single quotes)
Thanks again Agnivesh.
Is there a tutorial available on this online?
Upon setting US as Country, got following error-
can you please share your qvf file ?
Location type should be selected based on your State field.
This is wrong here.
Here is the qvf file (Without the change for Country in Location Scope).
make this setting
Thank you so much Agnivesh.
Your suggestion works perfect.
Can you please also point me to any docs or tutorials on Maps in QlikSense?