To add the geographical map of sales by country to the sheet, follow these steps:
- Before adding the map chart, resize the bar chart by reducing the width and making some room for the new chart at the bottom-right of the screen:
- Click on the Charts button that lies on the asset panel, which is on the left-hand side of the screen, to open the chart selector panel.
- Click on the Map button and drag and drop the chart into the empty space on the right-hand side of the sheet:
- The map visualization will show a default world map with no data, as follows:
Here, we need to add an Area layer to plot the countries, and add a Sales $ measure to fill in the area of each country with a color scale. Lower sales values will have lighter hues. Higher sales values will have darker hues.
To add the Area layer, follow these steps:
- Click on the Add Layer button in the properties panel on the right-hand side of the screen:
- Select the Area layer:
- Add the Country dimension, as it contains the information to plot the area:
- The map will show the country areas filled in with a single color, as follows:
- To add the Sales $ measure to set the color scale for each country, go to the asset panel at the left-hand side of the screen and click on the Master items heading in the Measures section. Drag and drop the Sales $ measure on top of the map:
- In the pop-up menu for the map, select Use in "Country"(Area Layer):
- After that, select Color by: Sales $:
- The map will now show the countries with more Sales $ in a dark color, and those with lower Sales $ in a light color:
Note that Qlik Sense automatically detects whether a field contains a valid country. Qlik Sense can show countries as areas and cities or municipalities as points automatically with the point layer.
- Now, click on the title of the object and type Sales $ by Country.
- Click on the Done button to enter the visualization mode. The sheet will look like this, but it will vary according to your screen resolution:
We now have a dashboard depicting the data of all of the order transactions for the entire years of 2016 to 2018. To finish the dashboard, we will add a filter panel to select the data by Order Year and Order Month (these fields are derived from the Order Date field).