You can adjust the appearance of visualizations in more detail using Advanced options. The Appearance section in the properties panel offers several options to set and modify the appearance of a visualization.
The settings available to you in the standard edit mode cover many options for changing the appearance of a visualization. Advanced options contains additional options for changing the appearance of a visualization, such as using expressions for titles, subtitles, and footnotes, or additional options for coloring charts by measure or expression.
Many of the settings have Auto options that support an optimal presentation of the visualization, taking into account the number of dimensions and measures and the type of data used. Normally, you do not need to change these settings, unless you have a special reason for doing so, for example, when space is very limited.
Appearance can be affected by the sorting of the dimensions and measures. For more information, see Change the sorting of a visualization.
Show titles: On by default in all visualizations except filter panes and text & image visualizations. Filter panes have the name of each dimension, and in most cases do not need any additional title. The text & image visualization includes an editing toolbar with many options to format the text, and therefore the title field can be used for other purposes.
Title, Subtitle, and Footnote: Apart from the obvious use of title, subtitle, and footnote as text fields, you can use these fields to also display an expression, which provides additional information that complements the measure in the visualization. You could, for example, show the totals in the title field, so that the totals of the selected values are always available.
In the following image, the total sales are calculated and used in the title. When a selection is made, the total sales are updated accordingly.
The following string was used to add the Total Sales expression to the field Title:
='Total Sales: $'& Round(Sum(Sales)/1000000, 0.1) & 'M'.
Because the title field is primarily a text field, it is necessary to start the string with an equals sign (=), to signify that the strings contains an expression.
Because 'Total Sales: $' is a text string when it is used in an expression, the string must be surrounded by single quotation marks.
& is used to concatenate the string and the expression.
Round(Sum(Sales)/1000000, 0.1) is the expression. The aggregation Sum(Sales) is divided by 1000000 and the function Round (x,0.1) reduces the number of decimals to one.
& 'M', finally, concatenates the expression with the unit M for million.
For the title there are three options for adding an expression:
- Directly in the title field of a visualization. Start the string with an equals sign (=).
- Directly in the box Title under Appearance in the properties panel. Start the string with an equals sign (=).
- Through the expression editor in the box Title. Click to open the expression editor. No equals sign is needed.
For the subtitle and footnote only the last two options are available.
Show details: Hide by default. When set to Show, users can click when analyzing to view details such as descriptions measures and dimensions.
Many of the presentation settings only apply to a certain visualization.
Set the bars to be displayed grouped or stacked, vertically or horizontally.
|Box plot||Select to show whisker ticks and grid lines. You can show the visualization vertically or horizontally.|
|Distribution plot||Select to show point, background or both. You can show the visualization vertically or horizontally.|
Set the gauge to be displayed as a radial or a bar. You can set range limits and use segments with limits.
|Histogram||Select to show grid lines.|
Set the line chart to be displayed as a line or an area.
Set the pie chart to be displayed as a pie or a donut.
Turn on/off navigation. Set the size of the bubbles in a scatter plot. Set the compression resolution for large data sets in scatter plot.
Set the totals to be displayed at the top, bottom, or not at all.
Set the headers, labels, overlay labels, and leaf values. Select to show the data values.
A bar chart with two dimensions is by default presented with the bars grouped.
Let us assume that you want to compare the total monthly quantity for these years. Then it would be a good idea to switch to a stacked bar chart.
In the properties panel, under Appearance > Presentation there is an option Stacked.
With stacked bars it is easier to compare the quantity between different months.
Now it is quite easy to compare the quantities per month. There is a legend to display the years.
Under Colors and legend, Show legend is set to Auto, which means that the legend is displayed when there is enough space. In the properties panel, you can also set where to display the legend and whether to display the legend title.
Colors and legend
The Colors and legend section of the properties panel sets your color and legend options. Qlik Sense automatically colors visualizations as they are added to your sheets. As a best practice, it is recommended to add or change colors only when it serves as purpose in the visualization. Too many colors or indistinct color choices can make visualizations less clear.
You can manually set the colors and legends by deselecting the Auto option and selecting your color preferences. Qlik Sense enables you to color your visualizations by:
- Single color
- Multiple colors
- Master items
For more information on different visualization coloring options, see Coloring a visualization. For examples of each of these methods of coloring visualizations and the settings used can be found, see Examples of visualization color settings.
For both the y-axis and the y-axis, you have options for deciding what combination of labels and title to display, as well as their orientation and position. Sometimes it may feel unnecessary to have labels and/or a title, because the visualization is self-explanatory and then it would be good to be able to hide them. Furthermore, when you create a visualization that is very small, for example, three by three squares, the labels are automatically hidden.
Range: The measure axis (usually the y-axis) has an option to set the range of the axis. By default, the range is adjusted according to the highest positive or the lowest negative measure value, but if, for example, a single measure value is much larger than all the other values, you may want to set a range that is suitable for the lower values. In the properties panel, under Appearance > Y-axis <measure name>, there is a button for Range, which is set to Auto. Click the button to switch to Custom. Now you can set the range for Max, Min, or both. In a bar chart, the bars that are out of the range are cut diagonally to indicate that they are out range. In a line chart, only the parts that are within the range are visible.
Label orientation: You can change the orientation of data labels on the dimensions axis (usually the x-axis). In the properties panel, under Appearance > X-axis <dimension name>, there is a drop-down menu for label orientation. By default, this is set to Auto. If there is not enough room for a label to fully appear on the chart, it will be truncated with an ellipsis. The following options are available:
Auto: Automatically selects one of the other options depending on the space available on the chart.
Horizontal: Labels are arranged in a single horizontal line.
Tilted: Labels are stacked horizontally at an angle.
Layered: Labels are staggered across two horizontal lines.