Sheet Element

This element allows you to add a complete dashboard sheet from your app to a report, with all the objects on there, including third-party elements and tables. Of course, in this case tables will automatically be included as images, but you can still combine this sheet element with all other report elements like true data-driven table objects, to enhance and complete your report with headers, cover sheets, page numbers, and more. 

Add sheet element

1. On the properties panel, click Report Elements > Add Element.
2. Click on Type and select Sheet from the dropdown list.

Select sheet from app

Now you can choose which of the sheets in your app should be applied. The list will automatically show all available sheets.

Caption

When you add a sheet element, the caption is automatically populated as "Sheet: " and the title of your selected app sheet.
You can rename this field to provide a meaningful caption that will help you in navigating through your report elements.

When enabling this element in the TOC, this caption will be shown by default, however you can choose a custom caption specifically for the TOC as well - learn more further below.

Sheet title

By default the title of your selected sheet will be added as a text element on the page with all the sheet objects. 

• Show Sheet Title: You can choose to disable the title.
• Sheet Title (empty for origin): You can override the default and set a customized title for this sheet element. Use the expression for dynamic content.
• Alignment options: Choose to align the text in this title element left, center, or right.

Link to URL

The Link to URL field allows you to add a link to the sheet element, respectively to all objects within. When the report is generated, the URL is embedded in it. Clicking one of the sheet objects on the report redirects the users to the URL specified here. This is particularly useful when you want users to access the live view of the object in the Sense environment (ensure they have sufficient access rights).

You can also use this to redirect users to a website, or any other kind of link.

NOTE: You will not be able to see or click the link in the Preview window. Download a draft report to verify the correct working of your link.

Calculation condition

In the Calculation Condition field, specify an expression to display the sheet element. It works just like the activation condition but is specific to each element. You can specify the value as a calculated formula. Refer to the Qlik documentation to know more.

Element Properties

The sheet element has no anchor or position settings, as it always begins on a new page and it automatically fills the whole page. Hence any subsequent elements in the report will start on the next page after the sheet element page.

Font

Click the Font tab to specify font properties of the text of the title object of your sheet element.

• Font Color: Use the color picker or provide a HEX code to choose the font color.
• Font Size: Specify the font size for table content. You can use the expression for dynamic sizing. 
• Font Style: Set the style to Normal, Bold, Italic, or Bold Italic.

These settings have no effect on any other objects within the sheet element, only the title.

Size

Size properties like width or height are not enabled for the sheet element, as it automatically covers one full report page. However, you can choose a different scaling to fit more chart content within the objects of this sheet element.

Scale

Scaling affects the content resolution of a chart object (or a table object, if Process Table as Image is enabled).

You can either provide a numeric value to define the scaling of the chart object or use an expression.
For example, if you have set the scale as 2, the chart scales twice in size, showing a more detailed view. The text gets smaller with a higher scale, but as this is still a dynamic web object at the time the image is taken in Qlik Sense, it adjusts on the container automatically and therefore may display more details.

Note that scaling is not zooming, and also does not increase the size of the chart. It increases or decreases the scale of the image while maintaining its aspect ratio of the page size. Therefore some objects like for example KPI charts won't show any difference, as they don't contain more information when increased. 

Of course this way the font size is reduced on your report, but combined with a high Image Quality and a larger Page Size, the scaling feature enables you to show a lot more information within your chart objects, that would otherwise only be available via scrolling on the live dashboard or reducing selections. On your generated PDF or PPTX report you can then zoom in to make all the information perfectly visible for readers.

Example:

Spacing

In a sheet element there is one additional property Margin between objects that applies to all the spaces between the objects within the sheet element.

The other properties define the distance of the sheet element as a whole from the header (if enabled) and page margins. You can do this separately for Left, Right, Top, and Bottom. 

Border

The Border setting is yet another property that is applied to all the objects within the sheet element. It defines the width (thickness) and color of the object borders.

Image Quality

In the Image Quality section you can define Image Processing, the dpi (dots per inch) settings, and Image Compression. All image quality properties will be applied to all the chart objects within the sheet element.

For Image Processing, you can select between two methods, Detailed and Fast:

• Detailed: Select this option to get a high image quality of charts. It takes around 3-6 seconds to process per each image/chart in the sheet, as it will include all the parts and details and offers higher dpi settings.
  You can select the image quality preset from Low (96dpi), Medium (192dpi), and High (384dpi), or specify a value in between. The lowest and highest values are limited by Qlik Sense.
• Fast: Select this option for faster image processing. However, some of the chart details (e.g. a legend or a caption) may not be rendered in the image. You cannot define any dpi settings for the fast mode, and the images are always displayed in low quality.

For Image Compression level, you can choose from Fast (low compression), Medium, or Slow (high compression) options. The Fast mode produces bigger file sizes and the Slow mode produces smaller file sizes.

TOC Table of Contents

If you added a TOC element to your report, you can choose for each other element (including this sheet element), if it should appear in the table of contents or not. In this case the sheet element only appears as one entry in the TOC and not all the objects within the sheet separately.

The following settings are available in this section:

• Show sheet element in TOC: This is enabled by default and also applies should the TOC be set to Bookmarks only.
• Indent: The indent can also be set individually for each element in your TOC, creating a topic hierarchy. 
• Label: By default the element's Caption is populated as a label in the TOC, but you can choose a separate one here just for display in the TOC. 
• Font Style: This property can also be set individually for each element in this corresponding TOC menu of each element.

Events

With the help of a little JavaScript you can create On Before Element events for making selections or setting bookmarks in your app, based on an individual element. If you are familiar with JavaScript and the Qlik API, have a look at the fx Expression Editor of this setting to see examples and code snippets.