Geo-Mapping Against Multiple Dimensions

[#1]

In Qlik Sense, I need to Geo-Map sales data against historical divisional structures (containing location data), and current divisional structures (also containing location data). So for example, the organisation has the following structure:

PeriodID	Sales	Current Sales Rep	Current Sales Unit	Current Sales Division	Current Sales State	Historical Sales Rep	Historical Sales Unit	Historical Sales Division	Historical Sales State
201015	1000	John	Bongo	Bam	Montana	Beau	Jamison	Tonto	Colorado
201020	1567	John	Bongo	Bam	Montana	Alex	Sender	Paleface	North Dakota

I want to run 2 maps -

• the first showing sales by state using the historical structure;
• the second showing sales by state using the current structure.

If I load the geo data twice and connect to both fields, when constructing the map, Qlik Sense does not seem to be able to identify the appropriate layer fields. The key field in the geo data that would match to the sales data is called State.

Can I load once as a data island, and then use set analysis or a variable to create the geo-map?

e.g. sum({<State = {[Historical Sales State]}>}Sales)

[#2]

Hi Richard,

You probably could load the kml file twice, if you make a copy and use different field names.

However the map in Sense in very limited, it would though be easy to do in IdevioMaps, here's an example with US state and zip data at QlikMarket.

Thanks,

Patric Nordström, Idevio