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.Dimensions / Measures
| Property | Use | Description |
|---|---|---|
| ID Dimension | required | The ID Dimension represents an identity of the the point. It can also be used as the Location ID. |
| Chart Dimension | required | The Chart Dimension is the dimension of the pie or bar chart at each point. |
| Chart dimension Label | default: | Alternative text that will be used as a label for the dimension instead of the dimension expression. If empty the Chart dimension will be used as label. |
| Latitude / ID | default: | The Latitude of the point (WGS 84) or the Location ID. |
| Longitude | default: | The Longitude of the point (WGS 84) |
| Chart Value | required | The value that is used in the pie or bar charts |
| Chart Value Label | default: | Alternative text that will be used as a label for the value instead of the value expression. If empty the Chart Value expression will be used as label. |
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. |
| Max no. 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. |
| In Resolution Limit | default:0 | The map will not be displayed when zoomed further in 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. |
| Out Resolution Limit | default:99999999 | The map 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. |
| Restrict Drill Down | default: | When the dimension is a drill down group it is possible to restrict the layer to be active only for a single level or multiple 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. Multiple levels can be specified separated with comma. This property is ignored if the dimension is not a drill down group. |
| 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:Checked | 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 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 |
|---|---|---|
| Color Legend Auto | default:Checked | 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 values based on if there is a color measure and its type. The second measure after the location controls color. When set to Custom more options are displayed, see below. |
| Colors drop down | default:By Dimension | Choose between "Single Color" "By Dimension", "By Measure" and "By Expression". "By Measure" is only displayed when there is a color measure. "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: Info Bubble
| Property | Use | Description |
|---|---|---|
| Show Info Bubble | default:Checked | When checked, a pop-up is displayed when hovering above the object. |
| Auto | default:Checked |
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. |
| Auto-Format Numbers | default:Checked | When Checked all numbers are formatted. When Unchecked, 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 available when "Format Numbers" is checked. |