Scatter plot properties

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.

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.

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.

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

You can also click 3 to create a dimension in the expression editor. To be able to edit a dimension that is linked to a master item, you must first unlink the dimension. Another way to create a dimension is to type the expression directly in the text box. Expressions added in this way must begin with an equals sign (=). Here is an example with a calculated dimension:

=If (Week < 14, Week, 'Sales')

If Add or Add alternative is dimmed, you cannot add more dimensions.

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

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.
• Cannot be used with a box plot.
• Does not affect the number formatting of the axis.

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.

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.

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.

Navigation: By default, off. When set to Auto, the navigation tool is displayed, with options to pan and zoom.

Bubble size: Set the size of the data point bubbles.

For a scatter plot with two measures, this sets the uniform size of all bubbles.

For a scatter plot with three measures, this sets the scale of the bubble sizes. In a scatter plot with three measures, the third measure controls the size of each bubble.

Labels: Select what labels to display:

• Auto: The number of labels displayed varies with the size of the visualization
• All: All labels are displayed. This option may cause labels to overlap.
• None: No labels are displayed.

.Compression resolution: Set the resolution for compressed data. Only available for large data sets (>1000 data points).

Grid line spacing: Select the spacing of the grid lines. The Auto setting is Medium.

Colors

You only need to select Custom if you want to change the settings. The Auto settings are based on the visualization used and the number of dimensions and measures, that is, the settings are not fixed, but are dependent on the data input.

Single color: A single color (by default blue) is used for all items in the chart. In visualizations that do not benefit from multiple colors (bar charts with one dimension and scatter plots), single color is the default setting. Use the color picker to change the dimension color.

Use library colors: Option available when a master dimension used in the visualization has a color assigned to it. You can select to use the master dimension color or to disable the master dimension color.

By dimension: By default, 12 colors are used for the dimensions. The colors are reused when there are more than 12 dimension values.

Persistent colors: When selected, colors are persistent between selection states. Only available when using one dimension and the setting By dimension.

Color scheme: Select 12 colors or 100 colors to be used for the different values. The 12 colors can all be distinguished by people with color vision deficiency, but not all of the 100 colors.

By 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 the coloring is by measure or 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.

Show legend: Not available when Single color is selected. By default set to Auto. The legend is displayed if there is enough space. The placement can be changed in the Legend position setting.

Show legend title: When selected, the legend title is displayed.

Labels and title: Select what to display of labels and title.

Position: Select where to display the axis.

Scale: Set the spacing of the axis scale.

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.