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