Chart Layer
A Chart Layer displays pie charts or bar charts at geographic locations. It takes one dimension to identify the point and one dimension for the diagram.
A measure controls the size of the bars or pies.
Example: Assume you have data with employment rate for postal code areas for a range of years. You then use the postal code as the first dimension as it identifies the location. As the second you put the year. Use the employment rate value as the measure The the layer will display a small bar chart for each postal area that shows the employment rate for each year and location.
Typically one dimension is a location id such as a postal code and the second is something that can be used on the x-axis in a diagram, such as year. A measure controls the length of the bars or size of the pie slices, such as employment. The max number of data points used for the charts (i.e. bars / slices) is 10 times the max number of objects as specified in the layer settings. So if each chart needs more than 10 bars or slices that value needs to be set accordingly, higher than the number of charts.For pie charts you can add an additional measure to control the size of the pies. Note that this measure works just over the first dimension so that it works as in bubble layer. That way the expression produces one value per pie, not one value per pie slice. The size is scaled linearly between the min radius and max radius specified under Appearance: Presentation.
Dimensions
The first dimension represents an identity of the the point. It can also be used as the location id, see "Location Options".
The second dimension is the dimension of the pie or bar chart at each point.
Measures
These are the measures. When coordinates are available (i.e. location source is longitude,latitude) specify measures like this:
- latitude - the latitude of the point (WGS 84)
- longitude - the longitude of the point (WGS 84)
- value - the value that is used in the pie or bar charts
- pie size value - optional measure that controls the size of the pies
- Location ID - an identifier that can be used for looking up a location (see Location Options)
- value - the value that is used in the pie or bar charts
- pie size value - optional measure that controls the size of the pies
- value - the value that is used in the pie or bar charts
- pie size value - optional measure that controls the size of the pies
Sorting
Standard Qlik sorting options that affect the order of pies or bars.
Layer Options
| Property | Use | Description |
|---|---|---|
| Map ID | default:<the most recent map of the sheet> | Specify this value when there is more than one map on a sheet to tell which map to display the layer on. See Map Id in Map Settings of the Map to get the right one. |
| Maximum Number of Objects | default:1000 | To display more than a thousand object increase this value. There will be a warning if there are more objects to display. |
| Calculation Condition | required | To limit when the layer is shown you can enter a caluclation condition as an expression. The layer is calculated/shown only when the expression is fulfilled. |
| Calculation Condition Message | required | A custom error message that will be displayed in the layers legend if the calculation condition is not fulfilled. Only visible if a calculation condition has been entered. |
| Zoom Limit | default:Min 0, Max 160000 | The layer will not be displayed when zoomed further in/out than these values. To set a limit to the current scale, drag the upper or lower limit towards the other and it will snap to the current scale. |
| Restrict Drill Down | default:0-16 | When the dimension is a drill down group it is possible to restrict the layer to be active only for a a range of levels. This makes it easy to create different layers that are active in the different levels of the drill down. The top level is number 0. The range selected specifies at what levels the layer should be visible. |
| Include in Auto Zoom | default:Yes | Determines if the layer should be included when calculating area to zoom to when automatically zooming to selections. |
| Draw Order | default:Auto | Defines how the layer should be drawn compared to other layers, which ones should be drawn on top of each other. |
| Draw Order Category | default:<Layer specific> | The layers are by default drawn after the base map and the base map labels in the order Geodata Layers, Area Layers, Heatmap Layers, Line Layers, Bubble Layers. To make this layer draw in another category, adjust this value. This property is only visible when "Draw Order" is set to "Custom". |
| Draw Order Adjustment | default:0 | Increasing this value makes the layer draw later, i.e. be more visible in the category. Allowed values are in the range -10 to 10. If you want the layer to be on top of other layers in the same category increase this value, if you want it to be overdrawn by other layers in the category decrease it. This property is only visible when "Draw Order" is set to "Custom". |
Location Options
Location information is either specified as longitude, latitude pairs, as identities that are looked up in an external service or as sense geometries.
When the term "Location ID" is used below it means it can be a sense geometry or an identity looked up else where.
When it starts with a "[" it is assumed to be a geometry in a string ([long,lat] is a point, [[long1,lat1],[long2,lat2],...] is a line,
[[[long1,lat1],[long2,lat2],...]] is a multi-line or a polygon with multiple rings, [[[[long1,lat1],[long2,lat2],...]]] is a multi-polygon but also accepted as a multi-line).
The external service can be something as simple as a geometry file or a more complex server based service.
The server based services provide a syntax for specifying more information on identities to minimize false hits.
For instance containing areas and types of features can be specified.
The following is the city Hamburg in Germany:
Hamburg,DE
and this is Hamburg in Sweden:
Hamburg,SE
If you actually wanted the first order administrative area in Germany named Hamburg you also need to specify a type:
Hamburg:AADM1,DE
You can also specify multiple areas when needed. For instance in USA there are many Hamburg. To get the one in Arkansas specify:
Hamburg,AR,US
See
Location Service Specification
for more information on syntax to use.
When there are unresolved names a warning is displayed in the upper left corner of the map.
| Property | Use | Description |
|---|---|---|
| Location Source | default:Auto |
Where location information comes from.
|
| Location Service | default:different for different types of geometries | URL to the location service. Either a server based service or a file as specified in "Location Service Type". An expression is accepted which makes it possible to change source dynamically. This can be used for switching file in different drill down levels for instance. |
| Location Service Type | default:Geometry service | The type of service used for location ID lookup. |
| Source Key Attribute | optional | The attribute in a geometry file to use as the location ID. This field is only visible when a file based geometry service is selected. |
| Advanced Location | default:false | The advanced location toggle controls whether to use Advanced Loction, in essence whether to use Location ID Suffix or to use Country and Type. |
| Country | default:any | The Country dropdown can be used to narrow down a lookup of a location id. Using Country is a simplified way of using Location ID Suffix (see below). |
| Type | default:any | The Type dropdown can be used to narrow down a lookup of a location id. Using Country is a simplified way of using Location ID Suffix (see below). |
| Location ID Suffix | default: |
The specified string is appended to all IDs.
This is a convenient way to specify more information to server based location services such as country code or type.
The alternative is to use an expression in the measure that appends extra information.
With the following suffix all items are specified to be cities in Sweden:
:P*,SE
See
Location Service Specification
for more information on syntax to use.
|
| Manual Remap | default: |
This provides an easy fix for incorrect location IDs. To change them to something else use a syntax like:
"value1":"remapped value1", "value2":"remapped value2", ... |
| Geometry Attribute | default:the_geom | The name of the attribute that contains the geometry (without name space). This field is only visible when Location Service Type is GML/WFS. |
| Reverse Coordinates | default:unchecked | Coordinates are expected in order latitude, longitude or Y, X. Check when coordinates comes in the other order. This field is only visible when Location Service Type is GML/WFS. |
Appearance: Legend
| Property | Use | Description |
|---|---|---|
| Show titles | default:Off | Display standard title. |
| Color Legend | default:Auto | Controls if visibility of the parts in the right side of the legend should be in Auto or Custom. |
| Show Colors | default:Checked | Turn on/off the color bar. This option is only visible when "Color legend" is Custom. |
| Show Color Min/Max Values | default:Checked | Turn on/off the text labels for color values. This option is only visible when "Color legend" is Custom. |
| Show Color Title | default:Checked | Turn on/off the label at the right side of the legend. This option is only visible when "Color legend" is Custom. |
| Show Icon Title | default:Checked | Controls if visibility of the left text which comes from the dimension label. |
| Show Icon | default:Checked | Controls if visibility of icon that symbolizes the pie or chart layer. |
Appearance: Presentation
| Property | Use | Description |
|---|---|---|
| Chart Type | default:Pie Charts | Choose between displaying data as pie charts or bar charts. |
| Min Radius | default:10 | Minimum radius of pies in pixels when scaled by a measure. When no scaling measure is used or all values are same the average of min and max radius is used. Only available when Chart Type is Pie Charts. |
| Max Radius | default:30 | Maximum radius of pies in pixels when scaled by a measure. When no scaling measure is used or all values are same the average of min and max radius is used. Only available when Chart Type is Pie Charts. |
| Height | default:40 | Height of largest value in the selection in pixels. Only available when Chart Type is Bar Charts. |
| Width | default:40 | Width of bars in pixels (per bar). Only available when Chart Type is Bar Charts. |
Appearance: Colors
| Property | Use | Description |
|---|---|---|
| Colors | default:Auto | In Auto the colors are mapped to dimension values if applicable. Otherwise a default single color is used. |
| Colors drop down | default:By Dimension | Choose between "Single Color" "By Dimension", "By Measure" and "By Expression". "By Dimension" lets you select a dimension to color by. "By Measure" lets you select a measure to color by. "By Expression" requires for technical reasons that there is at least one measure. Additional options are displayed for the particular choices. |
| Transparency | default:0 | A slider that controls transparency of objects from no transparency to invisible. |
| Outline Color | default:#aaaaaa | Determines outline color of features. If the field is empty the default value is used. All valid CSS colors can be used. |
Appearance: Label
| Property | Use | Description |
|---|---|---|
| Show Label | default:unchecked | When checked, the label defined by the expression is displayed at each object. |
| Label | default: | An expression that is displayed as a label next to each object. Only visible when "Show Label" is checked. |
| Out Resolution Limit | default:99999999 | The label will not be displayed when zoomed further out than this value. Check "Map.Debug.Show debug info" to see current resolution. The resolution is defined as meters per pixel, i.e. the number of meters each pixel covers. Only visible when "Show Label" is checked. |
| Set to Current Resolution | default: | A button that sets the label resolution limit to the current resolution. |
| Position | default:Below | The position of the label compared to the bubble. Available values are Below, Above and Centered. |
Appearance: Info Bubble
| Property | Use | Description |
|---|---|---|
| Show Info Bubble | default:Checked | When checked, a pop-up is displayed when hovering above the object. |
| Info Bubble | default:Auto |
When set to Auto, the dimension and measures are displayed in the pop-up.
When Custom, an expression defines what should be displayed.
HTML tags can be used for formatting.
For instance assuming there is a field [City Name]:
'This is <strong>' & [City Name] &'</strong>'
It is also possible to use javascript in the Info Bubbles. Simply add '<script>SOME JAVASCRIPT</script>' to the expression.
Only visible when "Show Info Bubble" is checked.
|
| Column Max Width | default:20 | The maximal allowed column width in characters for each column in the Info Bubble. If a value or header of a column is longer it will be truncated. Use this if the Info Bubbles get to wide. |
| Format Numbers | default:Checked | When checked, numeric values are rounded and displayed with suffixes such as k, M, G etc. Only visible when "Show Info Bubble" is checked. |
| Format | default:Auto | When Auto all numbers are formatted. When Custom, it is possible to specify which numbers should be formatted. Specify 1 for first number, 2 for second etc. Separate with comma. This option is only visible when "Format Numbers" is checked. |