Feature Layers - Line

Behind the scenes, Qlik Sense resolves the Dimensions and Expressions for QlikMaps exactly as it would for any out-of-the-box sheet chart object. It is often helpful to first build a Straight Table object before building a QlikMaps object in order to work out any data issues and problems with formulas that are unrelated to QlikMaps.

Line - Straight Table

An analogous straight table for a line layer is defined as follows:

• Dimension1: Line Dimension

• Dimension2: Line Boundaries

• Expression1: Popup Content

• Expression2: Line Outline Color

• Expression3: Outline Width

• Expression4: Outline Opacity

• Expression5: Outline Dash Pattern

Line - Dimension

Defines the lines being plotted. This value will be selected when lassoing.

Select lines as the dimension type and a field from the dimension drop-down.

Calculated dimensions can be created by selecting <Use Expression> from the drop-down. See Calculated Dimensions for syntax.

Line - Boundaries

QlikMaps will auto-select the boundary associated with the selected dimension.

If QlikMaps can't find an associated boundary field, a drop-down will display where a boundary field can be selected. Select a field that defines the boundary.

If you need to modify the auto-selected boundary, expand the dimension caption by clicking on it and select the gears to see the boundary field selector.

Line - Layer Title

QlikMaps will title the layer based on the dimension name.

To provide a customized layer title, expand the dimension caption and provide a layer title. This title will display in the layer control of the map.

Line - Size

Click on a predefined aggregation action and use the drop-down to select a metric to quickly build common expressions that will vary the width of the line.

More advanced expressions can be used by selecting 'Expression' from the drop-down.

  • If 'Value' is selected, the returned expression will be evaluated by QlikMaps and scaled appropriately based on the selected markers. The slider can be used to adjust the variance in size.
  • If 'Pixels' is selected, the returned expression will be evaluated as pixel size. If a static size is needed, use a number that represents the size in pixels.

Expand the 'Size' caption by clicking on it and select the gears to see advanced aggregation techniques.

Line - Color

Click on a predefined aggregation action and use the drop-down to select a metric to quickly build common expressions that will vary the size of the line.

More advanced expressions can be used by selecting <Use Expression> from the drop-down.

  • If value is selected, the returned expression will be evaluated by QlikMaps and scaled appropriately based on the selected lines. The slider can be used to adjust the variance in size.
  • If pixels is selected, the returned expression will be evaluated as pixel size. If a static size is needed, use a number that represents the size in pixels.

Expand the size caption by clicking on it and select the gears to see advanced aggregation techniques.

Line - Opacity

Expand the color caption by clicking on it to see the opacity slider.

Clicking on the gear Icon allows for an expression to be used for opacity instead of the slider. The expression must be a numeric value 0-100. If left blank, opacity is set to 100.

Line - Popup

Defines the popup content that appears when a user clicks on a line.

QlikMaps automatically generates popups where possible using the feature layer dimension and sizing expression.

A null value of ='-' will suppress popups on a per-row basis

Advanced popups can be created by unchecking auto generate popups and using an expression that returns HTML. Below are a few examples.

Line - Style

Defines the style of the lines.

Checking the curved will change lines from straight to curved.

Pattern can be changed using the pattern drop-down. Advanced techniques can be used by selecting expression from the drop down and using any expression that returns two numerical values separated by a comma. The first value represents the pixel length of a line segment. The second value represents the pixel length of the space between the line segments.

='5,10'

Directional arrows can be added by enabling the Show Direction Arrows check box. Arrow Location defines where the arrow will be represented on the line. Directional arrows do not work on multi-segment lines.

Line - Drilling

Drilling defines a selection path for moving from one layer to another.

  • In the parent drop-down select the layer drilled from
  • In the Before drilling... drop-down, select how to handle the current layer when the parent layer is visible.
    • Hidden creates the layer but hides it by default. The user can make it visible using the layer control. Note that  Hidden  uses RAM and CPU even while the layer is not visible.
    • Unavailable does not process the layer. It is not visible on the map or in the layer control. Unavailable uses NO RAM or CPU.
  • In the After drilling... drop-down select what to do with the current layer once the count of the of the current layer is 1.

If the drop-downs are used any time a single area or point is selected, the next more granular layer will be shown. If more control over drilling is necessary, select the gears icon to show the Show/Hide Expression and Calculation Condition.

  • The Show/Hide Expression can be any expression that returns either on or hidden.
  • The Calculation Condition can be any expression that returns either True() or False().

Line - Page Height

Page height is only displayed if the advanced settings box is checked under map settings.

Page height adjusts the number of features loaded on to a single layer at a time. The result will be the defined number of features (Points or Polygons) being loaded on to the map, and then more of the same number of features, until the cube height is reached.

Line - Cube Height

Cube height is only displayed if the advanced settings box is checked under map settings.

Cube height adjusts the maximum number of features to be loaded on to the map per layer.

Cube height needs to be an exact multiple of page height.