Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Geo-Mapping Against Multiple Dimensions

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:

PeriodIDSales

Current

Sales Rep

Current

Sales Unit

Current

Sales Division

Current

Sales State

Historical

Sales Rep

Historical

Sales Unit

Historical

Sales Division

Historical

Sales State

2010151000JohnBongoBamMontanaBeauJamisonTontoColorado
2010201567JohnBongoBamMontanaAlexSenderPalefaceNorth 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)

1 Reply
Not applicable

Re: Geo-Mapping Against Multiple Dimensions

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

Community Browser