New Straight Table Enhancements

[Jennell_McIntire]

The new straight table, found in the Qlik Visualization bundle, has two new enhancements in Qlik Cloud. The first is expression-based text styling and the second is measure modifiers. Let’s look at how these new enhancements can be used.

With the first enhancement, columns in a straight table can be styled based on an expression. This is done in the properties of a column in the Text style expression.

There are four styles that can be applied in the expression. They are:

1. Bold: <b> or <B>
2. Italics: <i> or <I>
3. Underlined: <u> or <U>
4. Strikethrough: <s> or <S>

In the expression, the style can be in written in uppercase or lowercase letters and it should be enclosed in single quotes. Here is an example of an expression that can be used to bold the text in the Customer column if the Customer is Boombastic.

The results in the table look like this:

To bold all the text in the Customer column, '<b>' can be used in text style expression without the if statement.

In the example below, the text in the Discount column and the Product Name column is strikethrough if the discount is equal to 0. The same expression below is used in both columns to format the text.

Text styles can also be combined in an expression. In the example below, the text is bold, italicized and underlined if the Sales value is greater than $1,000. Notice that all the style codes are included in the single quotes.

Multiple styles can be used in the same expression based on different criteria as well. For example, Sales values can be bold if over $1,000 and strikethrough if under $100.

While text styles can be combined, use with care and use the text styles to highlight something in the data, not clutter it.

The second enhancement of the new straight table are measure modifiers. Modifiers are not new to Qlik Sense, but they are new to the straight table. In the properties of a measure, there is an option to add a modifier. The four modifier options are: accumulation, moving average, difference and relative numbers (see image below). When a modifier is selected, other modifier settings will be made available for developers to edit as needed.

Let’s look at each modifier briefly. The accumulation modifier will accumulate the measure value over dimension(s). In the table below, the Sales – Accumulation value will accumulate over the Year Month dimension.

The moving average modifier will average the measure value over a specified period. In the properties below, the moving average modifier is set to full. Also notice the output expression which shows the expression used for the modified measure – this is available for all modifier options.

With these settings, the results off the modifier will look like the table below. With every row, the Sales value is included to calculate the new moving average.

The difference modifier will display the difference between the measure value as seen in the table below. In this case, the difference between the previous row and current row values.

The relative numbers modifier will display relative percentages that can change based on the properties selected. In the example below, the year 2023 is selected. If the selection scope is set to current selections, then the resulting table will show the percentages for 2023 only.

If the selection is disregarded, then the percentages ignore the 2023 selection and show percentages across all the month year timeframes. Below in the resulting table, the percentages are a lot lower since they are across a larger dataset.

To learn more about these enhancements, check out Qlik help using the links below.

Straight table

Modifiers

Thanks,

Jennell