Vizlib Home

Vizlib Finance Report Properties - Appearance and Row Styles

The Appearance section holds settings which control the format and look and feel of your finance report. You can modify the style of individual sheet items and apply overall settings such as header or row fonts, background color, column width and enabling scrollbars.   



In the General tab (Figure 1) you can choose to show or hide a title, add title details using the expression editors and show or hide report details, enable snapshots and display a maximize icon. 

Note: Snapshots have been part of the Hover Menu since the Qlik Sense September 2020 release, and the feature no longer controlled using the property panel.

Figure 1: General


Appearance settings are used to customize the look and feel of a finance report. 

You can set the Default background to stripes or fixed (Figure 2) choose the Background color for the whole report, enable Expanded Background to set colors for odd and even rows and set the Link color. You can also choose a Header color and Header text color, choose to Display measures... above or below column dimensions, and use Hide headers to display and position headers.

Figure 2: Default Background, Background and Header

To configure your dimensions display, you can enable Show dimensions dropdown, choose to Use first dimension as title, enter Dimensions Dropdown label and use Breadcrumbs as title. You can also Use browser scrollbars, Hide row hover to deactivate hover animation and enable a Top dimension separator

Column settings include setting a Min Column Width, choosing a Dimension column width from Default, Fixed or Relative (% of total width), and enabling Adjust headers width to adjust the header column width by Data or Text (Figure 3).

Figure 3: Dimensions and Column width

Row Styles

It's possible to style the rows from the property panel (Row Styles). By default, there are 4 styles but more (up to 99) can be added as needed. Every style has a number , eg. Regular (0), SubTotal(1). This number relates to the row style number in the excel file (see the section about the excel template) 

The following options are available (Figure 4). 

Figure 4: Row Styles

Striped Rows

Stripes are enabled in the property panel under Default background (Figure 5), with a choice of Stripes (displays stripe settings, applies stripes to all rows, including expanded rows) or Fixed (no stripes or stripe settings displayed). 

Figure 5: Default Background

Once activated, the user can change color for odd and even rows as well as the color of the text (Figure 6). Colors can be selected by either the color picker or as an expression that returns a color such as “=Green()“ or “=RGB(125,125,125) or even a hex color code.

Figure 6: Row Color

Expanded Rows and Stripes

Stripes in expanded rows can be turned off/on in Appearance using Expanded background settings. This allows striped normal rows and a fixed color on expanded rows, while different colors can be set for stripes to create a distinct pattern for expanded rows (Figure 7). 

Figure 7: Expanded Rows

Row Styles and Stripes

There is a setting in Row Styles to choose between using the preset background or the striped background setting. By default a couple of Row Styles are already in place.

When enabling striped rows, the striped setting is applied to all Row Styles. This can be enabled or disabled by the user, and each Row Style color overrides the stripe colors when the color is set to fixed.

Measure Colors and Stripes

A color expression in Data / Measures will always override a stripe setting. e.g. the expression '=Red()' in the background color expression of a measure will be used regardless of any Striped settings.

Enabling Breadcrumbs as title will show the dimension names as the title for the first column. The name of each dimension will appear as they are expanded in the table (Figure 8). 

Figure 8: Breadcrumbs as Title

Vizlib is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.