Skip to main content

The fourth sheet: Customer Location

ON THIS PAGE

The fourth sheet: Customer Location

This sheet focuses on customer location using a map.

You can create a map by adding point layers and area layers to display your data. You need to select a base map to provide the context for the layer data. You can add a measure value or an expression to the dimension values, and use the size of the points or color by measure to reflect the size of the measure.

Customer Location sheet when editing
Customer Location sheet when editing

Adding filter panes

Let us begin with the filter panes.

Do the following:

  1. Click Edit Edit in the toolbar.
  2. Add the filter pane Region.
  3. Add two new filter panes, one with the dimension City, the other with the dimension Customer.

Adding the map

In Qlik Sense you can create two types of maps, point maps and area maps. In Qlik Sense you can create maps that display data in point layers and area layers. The map we are using in this tutorial contains a point layer. A point layer is created using point coordinates (latitude and longitude) or location names to mark places of interest, for example cities.

Do the following:

  1. Drag a map chart to the sheet.
  2. In the properties panel, click Base map and select Pale.
  3. In the assets panel, click Fields and drag the field City onto the map.
  4. Select Add as new layer.
  5. Select Add as point layer.
  6. In the properties panel, in Layers, click the City point layer.
  7. In Location, after Location field, select the field Longitude_Latitude.
  8. In the assets panel, click Linked Object Master items.
  9. Locate Sales in Measures and drag it onto the map.
  10. Select Use in "City" (Point layer) and select Size by: Sales.
  11. In the properties panel, in Size & Shape adjust the Bubble size range slider. Too small a minimum and the bubble representing sales for one location may not be visible when compared to a location with a large sales volume.
  12. In Colors, set Colors from Auto to Custom.
  13. Select By measure in the list and in Select measure, select Sales.
  14. Add the title Location to the visualization.

  15. Click Edit Done in the toolbar.

The map size adjusts according to the selections made in the filters. For example, selecting Nordic will zoom the map into the North European area showing the locations of sales in that area.

Specific areas of the map can be selected by holding down the shift key, while using the mouse to draw a lasso around the area to be viewed. The selections in the filter panes then reflect the selection made on the map.

Selecting a specific location on the map shows the customers at that location in the filter panes. Selections in other sheets also affect the data shown in the Customer Location sheet.

Now you have finished the Building an App tutorial. Congratulations on your achievement of building a Qlik Sense app!

Now you can complement the app with data storytelling.