# 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
When location IDs are available as a measures (i.e. location source is measure), specify like this:
• 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
When location IDs are available as the first dimension (i.e. location source is dimension), specify like this:
• 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

Parameters for Layer Options
PropertyUseDescription
Map IDdefault:<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 Objectsdefault:1000 To display more than a thousand object increase this value. There will be a warning if there are more objects to display.
Calculation Conditionrequired 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 Messagerequired 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 Limitdefault: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 Downdefault: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 Zoomdefault:Yes Determines if the layer should be included when calculating area to zoom to when automatically zooming to selections.
Draw Orderdefault:Auto Defines how the layer should be drawn compared to other layers, which ones should be drawn on top of each other.
Draw Order Categorydefault:<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 Adjustmentdefault: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.
Parameters for Location Options
PropertyUseDescription
Location Sourcedefault:Auto Where location information comes from.
• Auto - Automatic determination of location source based on available measures and their types.
• Latitude, Longitude measures - Latitude and longitude values are provided in first two measures. For lines also the third and fourth measures are used as end point. This option is only available for point geometries (including start and end points for lines).
• Dimension - The dimension is the location id. This option is only available for point geometries (not lines or areas).
• Measure - The first measure is the location id. For lines there are two measure alternatives; One for a single location id for the entire polyline and one for using the first measure for the start point and the second for the end point.
Location Servicedefault: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. Note that when a file is loaded, it is always loaded via the GeoAnalytics server (as a proxy) to avoid javascript restrictions on cross-origin loading.
Location Service Typedefault:Geometry service The type of service used for location ID lookup.
Source Key Attributeoptional 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 Locationdefault: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.
Countrydefault: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).
Typedefault: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 Suffixdefault: 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 Remapdefault: 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 Attributedefault: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 Coordinatesdefault: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

Parameters for Appearance: Legend
PropertyUseDescription
Show titlesdefault:Off Display standard title.
Color Legenddefault:Auto Controls if visibility of the parts in the right side of the legend should be in Auto or Custom.
Show Colorsdefault:Checked Turn on/off the color bar. This option is only visible when "Color legend" is Custom.
Show Color Min/Max Valuesdefault:Checked Turn on/off the text labels for color values. This option is only visible when "Color legend" is Custom.
Show Color Titledefault: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 Titledefault:Checked Controls if visibility of the left text which comes from the dimension label.
Show Icondefault:Checked Controls if visibility of icon that symbolizes the pie or chart layer.

## Appearance: Presentation

Parameters for Appearance: Presentation
PropertyUseDescription
Chart Typedefault:Pie Charts Choose between displaying data as pie charts or bar charts.
Min Radiusdefault: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 Radiusdefault: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.
Heightdefault:40 Height of largest value in the selection in pixels. Only available when Chart Type is Bar Charts.
Widthdefault:40 Width of bars in pixels (per bar). Only available when Chart Type is Bar Charts.

## Appearance: Colors

Parameters for Appearance: Colors
PropertyUseDescription
Colorsdefault:Auto In Auto the colors are mapped to dimension values if applicable. Otherwise a default single color is used.
Colors drop downdefault: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.
Transparencydefault:0 A slider that controls transparency of objects from no transparency to invisible.
Outline Colordefault:#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

Parameters for Appearance: Label
PropertyUseDescription
Show Labeldefault:unchecked When checked, the label defined by the expression is displayed at each object.
Labeldefault: An expression that is displayed as a label next to each object. Only visible when "Show Label" is checked.
Out Resolution Limitdefault: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 Resolutiondefault: A button that sets the label resolution limit to the current resolution.
Positiondefault:Below The position of the label compared to the bubble. Available values are Below, Above and Centered.

## Appearance: Info Bubble

Parameters for Appearance: Info Bubble
PropertyUseDescription
Show Info Bubbledefault:Checked When checked, a pop-up is displayed when hovering above the object.
Info Bubbledefault: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 Widthdefault: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 Numbersdefault: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.
Formatdefault: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.