Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vkish16161
Creator III
Creator III

How to use the Add Layer feature in QS April 2018?

All,

Can anyone explain how to use the Add layer feature in the Mapping object?

I can't seem to figure it out.

Thanks!.

1 Solution

Accepted Solutions
seanbruton
Luminary Alumni
Luminary Alumni

Map example: Controlling visible data with drill-down layers

When creating a map that has multiple points of data located in a wide geographical area, you can use drill-down dimensions to display your layers in a hierarchy. As users make selections in a layer, the dimension displayed in the layer changes to the next dimension in the drill-down dimension. This enables you to use display data at different selection levels within your map, ensuring only the most relevant information is being displayed.

This example will show you how to build a map with a top-level area layer that drills down into with two point layers.

Example

We have a list of all historical sites in the United States National Park Service's National Register of Historic places. When we add the cities that historical sites are located in to a map as a point layer, we get accurate locations for our bubbles. It could be made more understandable with better organization, however.

How then can we organize this information better, especially if we also want to add in another point layer containing airports to help plan how to get to the different sites?

To solve this problem, we will create a map of the United States of America with a layer of states that drills down to the county level. Drilling down to the county level will also show the cities that contain the historical sites as data points, as well as all airports for that state and the surrounding states.

Dataset

This example uses two sets of data:

  • Federal listings: National Register of Historic Places listed properties from federal agencies (FED_LI_2015.xlsx)This data set is available from the National Park Service National Register of Historic Places. It contains data about all registered history places, their location, and the federal agencies associated to them.National Register of Historic Places Program: Research - Data Downloads When you use this data set, we recommend that you clean up the data as follows before loading it into Data manager:
    1. Delete the first empty rows of data.
    2. Convert rows 6 and 7 into a single header row.
  • Airport dataThis table contains data for airports in the United States. It consists of each airport's International Air Transport Association (IATA) code, city, and state or territory.You must import this data into Qlik Sense either by adding to a spreadsheet that you then import into Qlik Sense or by importing the table from this help page as a web file.ClosedAirport data

Instructions

Once you have loaded the data sets into a new app in Qlik Sense, you can begin building your map. To make the example map, you must complete the following tasks:

  1. Create the drill-down dimensions.
  2. Add the map to our sheet.
  3. Add the State-County area layer.
  4. Add the State-City point layer.
  5. Add the State-Airport point layer.
  6. Add the Resource filter pane.

Creating the drill-down dimensions

First, you need to create three drill-down dimensions. This will create the relationships between State and the fields County, City, and Airport, enabling the County, City, and Airport layers to become visible after a state from the State layer has been selected.Do the following:

  1. In sheet view, click @Edit in the toolbar.
  2. Click é to display the master items.
  3. Click Dimensions.
  4. Click Create new.
  5. Select Drill-down.
  6. Add the field State to the dimension.
  7. Add the field County to the dimension.
  8. After Name, type State-County.
  9. Click Add dimension.
  10. Add the field State to the dimension.
  11. Add the field City to the dimension.
  12. After Name, type State-City.
  13. Click Add dimension.
  14. Add the field State to the dimension.
  15. Add the field Airport to the dimension.
  16. After Name, type State-Airport.
  17. Click Add dimension.
  18. Click Done.

Adding the map to the sheet

The next step is to add a map to your sheet..Do the following:

  1. In sheet view, click @Edit in the toolbar.
  2. From the assets panel, drag an empty map to the sheet.

Adding the State-County area layer

The first layer you add is an area layer to which you add the dimension State-County. In addition, you set the country as 'USA'to ensure we map to the state of Georgia rather than the nation of Georgia.Do the following:

  1. From Layers in the properties panel, click Add layer.
  2. Select Area layer.
  3. In Dimensions, click Add and select State-County.
  4. Click Location.
  5. Set Scope for locations to Custom.
  6. After Country, enter 'USA'.
  7. After Administrative area (Level 1), select State.
  8. Click Colors.
  9. Set Colors to Custom, select By dimension, and select 100 colors.
  10. Select Persistent colors.
  11. Adjust the Opacity slider to half opacity.
  12. Click @ Done.

Adding the State-City point layer

The next layer you add is a point layer. You add State-City as the dimension and then set the country as 'USA' and then set State as the first-level administrative area, as some counties cities in different states have the same names.Do the following:

  1. From Layers in the properties panel, click Add layer.
  2. Select Area layer.
  3. In Dimensions, click Add and select State-City.
  4. Click Location.
  5. Set Scope for locations to Custom.
  6. After Country, enter 'USA'.
  7. After Administrative area (Level 1), select State.
  8. Click Colors.
  9. Set Colors to Custom, select Single color, and select a color.
  10. Click Options.
  11. In Layer display, set Visible drill-down levels to Custom.
  12. Clear State.
  13. Click @ Done.

Adding the State-Airport point layer

The final layer you add to the map is a point layer to which you add the State-Airport field as the dimension. Qlik Senserecognizes IATA codes for placement, ensuring the airports are located in their actual position rather than just in their city.Do the following:

  1. From Layers in the properties panel, click Add layer.
  2. Select Area layer.
  3. In Dimensions, click Add and select State-Airport.
  4. Click Location.
  5. Set Scope for locations to Custom.
  6. After Country, enter 'USA'.
  7. After Administrative area (Level 1), select State.
  8. Click Size & Shape.
  9. From Shape, select Triangle.
  10. Click Colors.
  11. Set Colors to Custom, select Single color, and select a color.
  12. Click Options.
  13. In Layer display, set Visible drill-down levels to Custom.
  14. Clear State.
  15. Click @ Done.

Add the Resource filter pane

Finally, you can optionally add a filter pane containing the field Resource. This provides you with a list of the available historical sites as you make selections within your map.Do the following:

  1. In the assets panel, drag and drop a filter pane into the sheet.
  2. Click Add dimension.
  3. Add a filter pane containing the field Resource.

View solution in original post

14 Replies
seanbruton
Luminary Alumni
Luminary Alumni

vkish16161
Creator III
Creator III
Author

Sean,

I'm not a partner. So I don't have access to this link. Is there any other way? Like a pdf of the page?

Thanks!

seanbruton
Luminary Alumni
Luminary Alumni

Map example: Controlling visible data with drill-down layers

When creating a map that has multiple points of data located in a wide geographical area, you can use drill-down dimensions to display your layers in a hierarchy. As users make selections in a layer, the dimension displayed in the layer changes to the next dimension in the drill-down dimension. This enables you to use display data at different selection levels within your map, ensuring only the most relevant information is being displayed.

This example will show you how to build a map with a top-level area layer that drills down into with two point layers.

Example

We have a list of all historical sites in the United States National Park Service's National Register of Historic places. When we add the cities that historical sites are located in to a map as a point layer, we get accurate locations for our bubbles. It could be made more understandable with better organization, however.

How then can we organize this information better, especially if we also want to add in another point layer containing airports to help plan how to get to the different sites?

To solve this problem, we will create a map of the United States of America with a layer of states that drills down to the county level. Drilling down to the county level will also show the cities that contain the historical sites as data points, as well as all airports for that state and the surrounding states.

Dataset

This example uses two sets of data:

  • Federal listings: National Register of Historic Places listed properties from federal agencies (FED_LI_2015.xlsx)This data set is available from the National Park Service National Register of Historic Places. It contains data about all registered history places, their location, and the federal agencies associated to them.National Register of Historic Places Program: Research - Data Downloads When you use this data set, we recommend that you clean up the data as follows before loading it into Data manager:
    1. Delete the first empty rows of data.
    2. Convert rows 6 and 7 into a single header row.
  • Airport dataThis table contains data for airports in the United States. It consists of each airport's International Air Transport Association (IATA) code, city, and state or territory.You must import this data into Qlik Sense either by adding to a spreadsheet that you then import into Qlik Sense or by importing the table from this help page as a web file.ClosedAirport data

Instructions

Once you have loaded the data sets into a new app in Qlik Sense, you can begin building your map. To make the example map, you must complete the following tasks:

  1. Create the drill-down dimensions.
  2. Add the map to our sheet.
  3. Add the State-County area layer.
  4. Add the State-City point layer.
  5. Add the State-Airport point layer.
  6. Add the Resource filter pane.

Creating the drill-down dimensions

First, you need to create three drill-down dimensions. This will create the relationships between State and the fields County, City, and Airport, enabling the County, City, and Airport layers to become visible after a state from the State layer has been selected.Do the following:

  1. In sheet view, click @Edit in the toolbar.
  2. Click é to display the master items.
  3. Click Dimensions.
  4. Click Create new.
  5. Select Drill-down.
  6. Add the field State to the dimension.
  7. Add the field County to the dimension.
  8. After Name, type State-County.
  9. Click Add dimension.
  10. Add the field State to the dimension.
  11. Add the field City to the dimension.
  12. After Name, type State-City.
  13. Click Add dimension.
  14. Add the field State to the dimension.
  15. Add the field Airport to the dimension.
  16. After Name, type State-Airport.
  17. Click Add dimension.
  18. Click Done.

Adding the map to the sheet

The next step is to add a map to your sheet..Do the following:

  1. In sheet view, click @Edit in the toolbar.
  2. From the assets panel, drag an empty map to the sheet.

Adding the State-County area layer

The first layer you add is an area layer to which you add the dimension State-County. In addition, you set the country as 'USA'to ensure we map to the state of Georgia rather than the nation of Georgia.Do the following:

  1. From Layers in the properties panel, click Add layer.
  2. Select Area layer.
  3. In Dimensions, click Add and select State-County.
  4. Click Location.
  5. Set Scope for locations to Custom.
  6. After Country, enter 'USA'.
  7. After Administrative area (Level 1), select State.
  8. Click Colors.
  9. Set Colors to Custom, select By dimension, and select 100 colors.
  10. Select Persistent colors.
  11. Adjust the Opacity slider to half opacity.
  12. Click @ Done.

Adding the State-City point layer

The next layer you add is a point layer. You add State-City as the dimension and then set the country as 'USA' and then set State as the first-level administrative area, as some counties cities in different states have the same names.Do the following:

  1. From Layers in the properties panel, click Add layer.
  2. Select Area layer.
  3. In Dimensions, click Add and select State-City.
  4. Click Location.
  5. Set Scope for locations to Custom.
  6. After Country, enter 'USA'.
  7. After Administrative area (Level 1), select State.
  8. Click Colors.
  9. Set Colors to Custom, select Single color, and select a color.
  10. Click Options.
  11. In Layer display, set Visible drill-down levels to Custom.
  12. Clear State.
  13. Click @ Done.

Adding the State-Airport point layer

The final layer you add to the map is a point layer to which you add the State-Airport field as the dimension. Qlik Senserecognizes IATA codes for placement, ensuring the airports are located in their actual position rather than just in their city.Do the following:

  1. From Layers in the properties panel, click Add layer.
  2. Select Area layer.
  3. In Dimensions, click Add and select State-Airport.
  4. Click Location.
  5. Set Scope for locations to Custom.
  6. After Country, enter 'USA'.
  7. After Administrative area (Level 1), select State.
  8. Click Size & Shape.
  9. From Shape, select Triangle.
  10. Click Colors.
  11. Set Colors to Custom, select Single color, and select a color.
  12. Click Options.
  13. In Layer display, set Visible drill-down levels to Custom.
  14. Clear State.
  15. Click @ Done.

Add the Resource filter pane

Finally, you can optionally add a filter pane containing the field Resource. This provides you with a list of the available historical sites as you make selections within your map.Do the following:

  1. In the assets panel, drag and drop a filter pane into the sheet.
  2. Click Add dimension.
  3. Add a filter pane containing the field Resource.

View solution in original post

alexcastorena
Contributor III
Contributor III

Hi Sean,

I tried the link though I could not log on. Would you have any qvf's that have this drill down.

Looking for US State drilling down to Cities.

Thanks,

Alex

burak_ersoy
Contributor III
Contributor III

Dear Sean Bruton,

Hope you are doing great! I would like to try this exercise above; however, some of the links are broken. Is it possible to update the links in your post? Or share another resource (i.e. GitHub) with qvf and/or data files.

Thank you for sharing great resource!

Sincerely,

Burak

vkish16161
Creator III
Creator III
Author

Burak,

All these features are now available live on QlikCloud.

You can try these features out by downloading some location based data from www.kaggle.com

burak_ersoy
Contributor III
Contributor III

Dear vkish16161

I am more interested in the training than data itself. Therefore, I was looking for the exact same data set in order to replicate the training material. Do you know any good resources that explains new mapping features with detailed examples? In other words, I am looking for a good step-by-step learning material instead of "Here are the New Features."

Thanks,

Burak

alexcastorena
Contributor III
Contributor III

Your step by step instructions were very helpful. Thank you for posting.