Skip to main content
News   #Feature Friday – Parallel Report Execution

#Feature Friday – Customize the look of your Qlik®-report tables using table styles

News

Welcome to today’s #Feature Friday!

Reporting thrives on reducing the amount of data and correctly interpreting the numbers. That is why complex information should be presented in a simple and structured way. Managers and other decision-makers do not want to keep an eye on all available data and facts. They only need a few, but meaningful figures.

Therefore, two things are important: the selection and the display. It is important to select the really important numbers and to present them in an easily understandable way. In this context, tables are indispensable in controller practice. Much of the information available is presented in tabular form. While charts help to show numbers visually.

Tables are primarily used when exact values are to be displayed compactly. They bring attention to the actual figures. In addition, the simple table formatting increases your audience’s comprehension of the underlying data and vastly improves the aesthetic quality of your report.

However, formatting tables can sometimes be a challenge when it comes to displaying numeric information from QlikView® or Qlik Sense® in a table in a report. You may want Microsoft Word® or PowerPoint® to align the numbers in the table correctly.

Today, we show you how styling tables is a breeze with Mail & Deploy:

Custom Table Styles

In Mail & Deploy, you can apply table styles to your table elements to format them quickly and consistently. You can edit table styles by modifying text style (character formatting), background (shading), borders and padding in Column specifications > Style.

Thus, if your document includes multiple tables, this feature can save a lot of time and hassle.

Column Specification

You can either apply one of the four different application modes for the style value or just use the Mail & Deploy native functions to achieve conditional formatting. This is especially useful when creating non-Excel Reports.

The 4 different application modes are:

None.
If a style value has this application mode, the associated property will not be set in the report document and whatever is the default for the report type will be kept.

Keep Original. 
If a style value has this application mode, the associated property will be set to the value that has originally set; e.g. when a table report element is read from a data source, the original value of that style in the data source will be kept.

Constant Value.
If a style value has this application mode, the associated property will be set to a constant value.

Expression.
If a style value has this application mode, the associated property will be set to a value evaluated from an expression.

Data Table Cell Style
Native functions for conditional formatting

Check out the video below for a full overview of how to utilize this feature:

Styling your Qlik®-Report Tables in Mail & Deploy

For more detailed information, you can also reference our Mail & Deploy Knowledge Base Article about table styles in Mail & Deploy.

Mail & Deploy lets you customize the look of your report tables using custom table styles, which means you can match Qlik®-reports to your organization’s branding and colours. This feature is a quick way to format tables consistently and easily and helps you to increase your audience’s comprehension of the underlying Qlik®-data.

Happy table styling with Mail & Deploy!

If you have questions or need support, please contact us at support@mail-and-deploy.com

Share article