Waterfall chart properties

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Ö.

Select how to use the measure in the chart:

• Add: The measure value is added.
• Subtract: The measure value is subtracted.
• Subtotals: The measure value is treated as a subtotal value of the last measures using the same measure operation.

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: 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 as an integer with a thousands separator. In this example " " is used as a thousands 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.
• Does not affect the number formatting of the axis.

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.

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.

Gridline spacing: Set this to Custom if you want to customize the horizontal gridlines. You can choose between:

• No lines
• Medium
• Narrow

Value labels: Set this to Off if you want to hide value labels on bars.

Colors: You can set the presentation color for the different measure operations:

• Positive value color
• Negative value color
• Subtotal color

Legend: Set to Auto to show a legend of the measure operations. You can set the position of the legend with Legend position:

• Auto: The legend is automatically positioned where there is available space.
• Right
• Bottom
• Left
• Top

Labels: Select if you want to show labels on the Y-axis.

Position: Select where to display the dimension axis.

Scale: Select how many lines you want to show on the Y-axis. Narrow shows many lines, and Wide shows few lines.

Range: Select to set the min value, the max value, or both. The min value cannot be larger than the max value. You can use expressions for the values.