1 Reply Latest reply: Dec 8, 2015 4:35 AM by Patric Nordström RSS

    Geo-Mapping Against Multiple Dimensions

    Richard Blakemore

      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)