Skip to main content Skip to complementary content

Table properties

You open the properties panel for a visualization by clicking @Edit in the toolbar and clicking the visualization that you want to edit.

If the properties panel is hidden, click h in the lower right-hand corner to open it.

Information noteIf the visualization has é in the upper right-hand corner, the visualization is linked to a master item. You cannot edit a linked visualization, but you can edit the master item. You can also unlink the visualization to make it editable.
Information noteSome of the settings in the properties panel are only available under certain circumstances, for example, when you use more than one dimension or measure, or when you select an option that makes other options available.

Data

Click Add column to add a dimension or a measure. Options that are dimmed are not available.

Columns

In the table, the dimensions and measures are presented together under the heading Columns.

Dimension settings

Add column

On the Data tab, click Add column and select Dimension to open a list of available Dimensions and Fields. Select the dimension or field that you want to use.

A dimension can either be selected from the list of already existing Dimensions, or created from the list of available Fields.

To edit a dimension that is stored as a master item, you must first unlink the dimension from the master item.

<Dimension name> Click the dimension name to open the dimension settings. If you want to delete the dimension, long-touch/right-click the dimension and select Delete in the dialog. Alternatively, click the dimension and click DeleteÖ.
Dimension Only displayed for master items. To be able to edit a dimension that is linked to a master item, you must first unlink the dimension.
Field

If you have added a field from Fields in the assets panel, the field name is automatically displayed. Click 3 to open the expression editor.

Label Enter a label for the dimension. If you have added a field from Fields in the assets panel, the field name is automatically displayed.
Include null values When selected, the measure values of all null dimensions are summarized and presented as one dimension item in a visualization. All null values are displayed as gaps or dashes (-).
Limitation

Limits the number of displayed values. When you set a limitation, the only dimensions displayed are those where the measure value meets the limitation criterion.

No limitation: The default value.

Fixed number: Select to display the top or bottom values. Set the number of values. You can also use an expression to set the number. Click 3 to open the expression editor.

Exact value: Use the operators and set the exact limit value. You can also use an expression to set the number. Click 3 to open the expression editor.

Relative value: Use the operators and set the relative limit value in percent. You can also use an expression to set the number. Click 3 to open the expression editor.

Calculated on measure: <measure>: Shown when you make a limitation to the number of displayed dimension values. The dimensions whose measure value meet the criterion are displayed.

Background color expression Enter an expression for the background color. The text color automatically changes to white when a dark background color is used.
Text color expression

Enter an expression for the text color. If you use the same expression as in the background color, the text will not be visible.

See: Coloring a visualization

Text alignment When set to Custom, you can select how to display the content: Align left or Align right. If Text alignment is set to Auto, the alignment is automatically aligned left or right, depending on the content.
Representation

When set to Text, all values are displayed as static text. When set to URL, field values that contain a URL are displayed as clickable links. Clickable links open a new browser tab.

Show others When selected, the last value in the visualization (colored gray), summarizes all the remaining values. When some kind of limitation is set (Fixed number, Exact value, or Relative number), the value counts as 1 in that setting. If, for example, Exact value is used and set to 10, the tenth value is Others.
Others label

Enter a label for the summarized values (when Show others is selected). You can also use an expression as a label. Click 3 to open the expression editor.

Measure settings

Add column

On the Data tab, click Add column and select Measure to open a list of available measures. Select the measure that you want to use. If you select a field, you are automatically presented with some common aggregation functions that you can choose between for the measure.

To edit a measure that is stored as a master item, you must first unlink the measure from the master item.

<Measure name> Click the measure to open the measure settings. If you want to delete the measure, click E.
Measure Only displayed for master items. To be able to edit a measure that is linked to a master item, you must first unlink the measure.
Expression Click 3 to open the expression editor. The existing expression is displayed by default.
Label Enter a label for the measure. Measures not saved in Master items are, by default, displayed with the expression as label.
Number formatting

Different options for formatting the measure values. If you want to change the number format at app level, and not just for a single measure, it is better to do that in the regional settings, that is, in the SET statements at the beginning of the script in the data load editor.

Auto: Qlik Sense automatically sets a number formatting based on the source data.

Number: By default, the formatting is set to Simple, and you can select the formatting from the options in the drop-down list. Click the button to change to Custom formatting, and use the Format pattern box to change the format pattern.

Examples:  

# ##0 describes the number as an integer with a thousands separator. In this example " " is used as a thousands separator.

###0 describes the number as an integer without a thousands separator.

0000 describes the number as an integer with at least four digits. For example, the number 123 will be shown as 0123.

0.000 describes the number with three decimals. In this example "." is used as a decimal separator.

If you add the percent sign (%) to the format pattern, the measure values are automatically multiplied by 100.

Money: By default, the format pattern used for money is the same as set up in the operating system. Use the Format pattern box to change the format pattern.

Date: By default, the formatting is set to Simple, and you can select the formatting from the options in the drop-down list. Click the button to change to Custom formatting, and use the Format pattern box to change the format pattern.

Duration: By default, the format pattern used for duration is the same as set up in the operating system. Duration can be formatted as days, or as a combination of days, hours, minutes, seconds and fractions of seconds.

Custom: By default, the format pattern used for custom is the same as set up in the operating system. Use the Format pattern boxes to change the format pattern.

Measure expression: The format pattern is determined by the measure expression. Use this option to display custom number formatting for a measure in a visualization.

Limitations:

  • Only works with visualizations that accept measures.
  • Cannot be used with a box plot.
  • Does not affect the number formatting of the axis.
Background color expression

You can use coloring by expression to accentuate certain values. Supported formats: RGB, ARGB, and HSL.

Expression: Enter the expression that you want to use. Click 3 to open the expression editor.

The expression is a color code: Selected by default. In most cases, it is best to keep this setting. When the selection is cleared, the expression evaluates to a number, which in turn is plotted against one of the chart gradients.

See: Coloring a visualization

When coloring by expression, you can set the color range (Min and Max values). By setting the color range, the colors remain constant throughout selections and paging. When using color by expression, the option The expression is a color code must be cleared before you can set the color range.

Background text expression
Decimal separator Set the decimal separator.
Thousands separator Set the thousands separator.
Format pattern Set the number format pattern.
Background color expression Enter an expression for the background color. The text color automatically changes to white when a dark background color is used.
Text color expression

Enter an expression for the text color. If you use the same expression as in the background color, the text will not be visible.

See: Coloring a visualization

Totals function Select which aggregation function you want to use for the Totals row in the table. You set the position of the Totals row under Presentation.

Sorting

Drag the dimensions and measures to set the sorting priority order. The numbers show the order.

Each of the dimensions and measures can also be sorted internally:

Click the dimension or measure name to open the settings and click the sorting button to switch to Custom sorting. The following table shows the internal sorting priority order and sorting options. The sorting is either Ascending or Descending.

Sorting options Comment
Sort by expression Enter an expression to sort by. Only available for dimensions.
Sort numerically  
Sort alphabetically  

Additionally, you can sort by load order by switching to Custom and leaving all sorting options unselected.

If you have set a custom order for a field, that custom order will override any selected internal sort order in Sorting. See Customizing the order of dimension values.

Add-ons

Data handling

Calculation condition: Specify an expression in this text field to set a condition that needs to be fulfilled (true) for the object to be displayed. The value may be entered as a calculated formula. For example: count(distinct Team)<3. If the condition is not fulfilled, the message or expression entered in Displayed message is displayed.

A calculation condition is useful when a chart or table is very big and makes the visualization slow to respond. A calculation condition can then help so that for example an object does not show until the user has filtered the data to a more manageable level by applying selections.

Include zero values: When unselected, measures that have the value ‘0’ are not included in the presentation. If there is more than one measure value, all the measure values must have the value ‘0’ to be excluded from the presentation.

Appearance

General

Show titles: On by default in all visualizations except filter panes, KPIs, and text & image visualizations.

Enter Title, Subtitle, and Footnote. By default, the string is interpreted as a text string. However, you can also use the text field for an expression, or a combination of text and expression. An equals sign (=), at the beginning of a string shows that it contains an expression.

Click 3 if you want to create an expression by using the expression editor.

Example:  

Assume that the following string is used, including quotation marks: 'Sales: ' & Sum(Sales).

By default, the string is interpreted as a text string and is displayed as presented in the example. But if you begin the string with an equals sign: (='Sales: ' & Sum(Sales)), the string is interpreted as an expression instead. The output is then Sales: <value of expression>, where <value of expression> is the calculated value.

Show details: Set to Show if you want to allow users to be able to choose to view details, such as descriptions, measures, and dimensions.

Show detailsHide by default. When set to Show, users can click ] when analyzing to view details such as descriptions measures and dimensions.

Presentation

Totals

Auto: The totals (the result of the expression), are automatically included at the top of the table.

Custom: Select whether to display the totals and where to display them, at the top or bottom.

Totals label: Set the label for the totals row. You can also use an expression as a label.

Scrolling

You can select to freeze the first column from horizontal scrolling.

Information noteIt is not possible to freeze the first column on touch devices.

Multiline text wrapping

You can enable or disable multiline text wrapping in headers and cells separately.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!