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.
Data
Measures
| <Measure name> |
Click the measure to open the measure settings. If you want to delete the measure, long-touch/right-click the measure and select Delete in the dialog. Alternatively, click the measure and click DeleteÖ. |
| 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. To represent numeric abbreviations, the international SI units are used, such as k (thousand), M (million), and G (billion). 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: # ##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:
|
| Decimal separator | Set the decimal separator. |
| Thousands separator | Set the thousands separator. |
| Format pattern | Set the number format pattern. |
| Add measure |
On the Data tab, under Measures, click Add measure to open a list of available measures. Select the measure that you want to add to the visualization. If you select a field, you are automatically presented with some common aggregation functions that you can choose between for the measure. If no measure is available, you need to create one. You can enter the expression directly in the text box, or click 3 to create a measure in the expression editor. To be able to edit a measure that is linked to a master item, you must first unlink the measure. If Add measure is dimmed, you cannot add more measures. |
Add-ons
| Reference lines |
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. Add reference line: Click to add a new reference line. Show: When selected, the reference line is displayed. Label: Enter a label for the reference line. Color: In the color picker, select the color of the reference line and the label. Reference line expression: Enter a value or an expression for the reference line. Click 3 to open the expression editor. |
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 details: Hide by default. When set to Show, users can click ] when analyzing to view details such as descriptions measures and dimensions. |
| Presentation |
Range limits Min: Set the minimum value for the gauge. Click 3 if you want to create an expression. Max: Set the maximum value for the gauge. Click 3 if you want to create an expression. Radial/Bar.Select to display the gauge as a radial or as a bar. Select vertical or horizontal orientation of the visualization. Only available for bar gauges. Use segments: When not selected, a single color (by default blue) is used to illustrate the value. When selected, you can divide the gauge into segments with different colors. When segments are used, a pointer marks the value. Click Add limit to add a segment to the gauge. Use the slider or type an expression to set the limit. Click 3 to create an expression. You can add several segments. Click the segment to change colors. Remove limit: Click to remove the selected limit. Gradient: Select to use different shades of colors in the transition between the segments. Use library: Option when a master measure used in the visualization has a color assigned to it. You can select to use the master measure colors or to disable the master measure color. This option is not available if Use segments is enabled. |
| Measure axis: <Measure> |
Labels and title: Select what to display of labels and title. Scale: Set the spacing of the measure axis scale. |
Learn more
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!