How to create QLIK maps?

How to create QLIK maps?


If you want to create a QLIK map you need a file with a geometry that is used to plot areas (polygons) and points (latitude, longitude) on the map. The spatial data formats that QLIK supports are KML (.kml) files. QLIK also supports CSV and Excel files with a latitude and longitude value if you want to create a map with points like addresses or business listings. Both maps need a different approach.

Create a point map in QLIK Sense with Spotzi data

  1. Export or download your point map from your Spotzi Mapbuilder account to CSV.
  2. Open the CSV in Excel and divide the geometry column “POINT(longitude latitude)” into a separate longitude and latitude column. Delete the POINT text and brackets and separate the longitude and latitude value with the Data > Text to Columns functionality. Give your colums the names “longitude” and “latitude” so QLIK Sense automatically knows which columns contain a geometry.
  3. Save your CSV.
  4. Now go to your QLIK Sense software and create a new app.
  5. Name your app and click CREATE.
  6. Click OPEN APP.
  7. Drag you KML file into your app or go to data manager in the upper left corner and select the KML from your computer.
  8. Now you will see the columns from your KML file. Select the name and area column and click ADD DATA.
  9. After your import is done, click the particular data set and click LOAD DATA in the upper right corner.
  10. After your data was loaded successfully, click on EDIT THE SHEET to open your visualization where you can add your map.
  11. Drag a map chart to your sheet.
  12. Now drag the field item with the geometry to your map. This is in most cases the field that ends with “.Area”.
  13. Click ADD A NEW LAYER > ADD AS AREA LAYER.
  14. You have successfully created a QLIK Sense point map with Spotzi data.
QLIK Sense Boundary Map
Real estate data in QLIK Sense

How do I create a QLIK Sense visualization with Spotzi data?

Did you find a data set you like in our DataShop? Please follow these steps to import our KML files and create your very own QLIK sense visualization.

  1. After you bought your data set, you can export your data to a KML file. Please make sure that the column that contains the ZIP code has the title “name”.
  2. Create a new app.
  3. Name your app and click CREATE.
  4. Click OPEN APP.
  5. Drag you KML file into your app or go to data manager in the upper left corner and select the KML from your computer.
  6. Now you will see the columns from your KML file. Select the name and area column and click ADD DATA.
  7. After your import is done, click the particular data set and click LOAD DATA in the upper right corner.
  8. After your data was loaded successfully, click on EDIT THE SHEET to open your visualization where you can add your map.
  9. Drag a map chart to your sheet.
  10. Now drag the field item with the geometry to your map. This is in most cases the field that ends with “.Area”.
  11. Click ADD A NEW LAYER > ADD AS AREA LAYER.
  12. Remember that QLIK Sense will limit the number of areas. If you want to change this, go to the particular area layer and click OPTIONS > GENERAL and set the number of max. visible objects to a number more than 1000.
  13. Show labels by clicking the switch. Select the field that ends with “.Name” to visualize the postal codes.
  14. You have successfully created a QLIK Sense visualization with Spotzi data.
QLIK Sense Boundary Map
Spotzi 4-digit Boundaries of the Netherlands in QLIK Sense

Database with 100+ KML Files

Spotzi has a large Datashop with a lot of KML (.kml) datasets with demographics, consumer spending, ZIP code boundaries, real estate data, addresses, business listings and many more. Our Datashop offers a one-stop-shop solution where you can browse through all our datasets and order them directly from our shop.