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 in the lower right-hand corner to open it.
Columns
| Add column |
Click Add column to open a submenu where you can choose to add a dimension or a measure. When you have made your choice, a list of matching items is displayed. Select the item 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. A measure can either be selected from the list of already existing Measures, or created from the list of available fields. 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 dimension or measure that is stored as a master item, you must first unlink the dimension or measure from the master item. |
Depending on whether you are working with a dimension or a measure, you have different options. The following sections describe the settings for dimensions and measures.
Dimensions
| <Dimension name> | Click the dimension name to open the dimension settings. If you want to delete the item, click . |
| 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 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. |
| Show 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 |
Limit the number of displayed values. 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 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 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 to open the expression editor. |
| Show others | (Not available with tree maps and stacked bar charts.) 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 |
Set the label for the Others value. You can also use an expression as a label. Click to open the expression editor. |
Measures
| <Measure name> | Click the measure to open the measure settings. If you want to delete the measure, click . |
| 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 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 and 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. Examples: # ##0describes the number as an integer with a thousands separator. ###0describes the number as an integer without a thousands separator. 0000describes the number as an integer with at least four digits. For example, the number 123 will be shown as 0123. 0.000describes the number with three decimals. 0.0##describes the number with at least 1 decimal and at most three decimals. 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. 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 also: Coloring by expression |
| Decimal separator | Set the decimal separator. |
| Thousands separator | Set the thousands separator. |
| Format pattern | Set the number format pattern. |
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 |
|---|---|
| 1. Sort by expression | Enter an expression to sort by. Only available for dimensions. |
| 2. Sort numerically | |
| 3. Sort alphabetically |
Appearance
|
General |
Show titles: On by default in all visualizations except filter panes and text & image charts. 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 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. |
| 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. |