Skip to main content Skip to complementary content

Structuring an app using sheets

Sheets structure your ideas and purpose of your app. When you create an new app, it is good practice to first build a structure of empty sheets, where each sheet represents an idea or a goal. This gives a good overview of the app.

Overview

For example, you are creating an overview of your company's key metrics, sales, and margins by state, region, and product. Instead of having all this information in one place, you could structure it by having one sheet for each purpose.

Each sheet has a purpose and an idea of its own.

Three different sheets.

A sheet is where charts and tables for data visualization are placed. An app can include several sheets. The selections that you make affect visualizations regardless of which sheets they are on.

An example of a sheet with boxes on the left to select and filter out the data to be presented in the visualizations on the right.

Sheet with visualizations.

Creating a new sheet

You can create a new sheet from the app overview or from the assets panel.

Tip noteYou access the sheet navigator from the sheet view by clicking App objects in the toolbar.

Do the following:

  1. From the app overview, click App objects to view the sheets.
  2. Click Create new sheet.
  3. Give your sheet a title and add a description.
  4. Click outside the text area to save the title and description.

A new sheet is created.

Changing the title and description of a sheet

You can change the title and description of your sheets. You can either use a fixed sheet title, or a dynamic sheet title based on an expression.

  1. In the app overview, click App objects to view the sheets.
  2. Do one of the following:
    • If you are in grid view, Grid View, click the sheet title followed by clicking Edit.
    • If you are in list view, List view, click Edit.
  3. Edit Title and Description.
  4. Click outside the text area.
The changes you made are saved.
Tip note

You can also change a sheet’s title by clicking on it in the sheet editor.

In Advanced options, you can change the title and description in the Sheet properties panel.

Using a dynamic sheet title

In Advanced options, you can set a dynamic sheet title based on an expression in the Title expression property of the sheet properties panel. You can use any valid chart expression. For more information, see Using expressions in visualizations.

If you set a dynamic sheet title, the fixed title (Title) is not used.

Creating dynamic sheet titles using expressions

Setting a show condition for a sheet

You can set a condition in Show condition to show or hide a sheet in an app depending on if an expression evaluates as true or false. The sheet is only shown if the expression evaluates as true. Hiding a sheet does not hide or exclude data in an app.

For example, you could create a sheet that is only available if certain values are present in your data. Typically, you should use an if function. For more information, see if - script and chart function.

Setting a show condition for a sheet

Changing the sheet thumbnail

In Advanced options, you can replace the default thumbnail, to make it easier to distinguish between sheets in the app overview and in the assets panel. You can use one of the default images, or an image of your own.

Note the following:

  • The following formats are supported: .png, .jpg, .jpeg, and .gif.
  • The optimal aspect ratio of a thumbnail is 8:5 (width:height).
  • You can only add or change the thumbnail of a private sheet.
  1. In the app overview, click App objects to view the sheets.
  2. Do one of the following:
    • If you are in grid view, Grid View, click the sheet title followed by clicking Edit.
    • If you are in list view, List view, click Edit.
  3. Click Image on the default thumbnail.

    The Media library opens.

  4. Click on a folder in the media library, for example In app or Default.

  5. Select the image you want to use as a thumbnail for the sheet and click Insert.
  6. Click Checkmark to stop editing.

The image you selected is now used as a thumbnail for the sheet, and is visible in the assets panel and in the app overview.

Tip noteYou can also change a sheet’s thumbnail in the assets panel or in the Sheet properties panel.

Fore more information, see Managing a Qlik Sense site: Uploading objects to content libraries.

Changing the grid sizing of a sheet

You can adjust the grid sizing of the sheet to be able to fit more visualizations on a sheet, or have more control over how visualizations are positioned. The grid displays when you are adding, moving, or resizing a visualization.

Grid size can be changed in the Sheet properties pane

The sheet properties pane
  1. Go to the Grid spacing setting under Sheet properties.
  2. Change spacing from Wide (the default option) to Medium, Narrow, or Custom.
  3. If you choose Custom, a slider will appear. Use the slider to change the grid size. The higher the number, the more narrow the grid spacing is.

Customizing sheet size

By default, Qlik Sense uses a responsive layout for sheets that adjusts the sheet to the dimensions of the user’s screen. You can set a custom width and height for the sheet if you want to use a non-responsive layout for your sheets. This ensures that your dashboard will be presented to users exactly as you created them, with no adjustments for responsiveness. You can set the height and width of a sheet anywhere between 300 pixels and 4,000 pixels.

If the PDF download of your sheet appears overly zoomed in, switching the Sheet size from Responsive to Custom is recommended.

Information noteChanging the Sheet size from Responsive to Custom may impact the interactive experience for business users. If report output formatting is particularly important, consider creating a report-specific app for better control over themes and layout.

When a sheet is using a custom size, you can change the grid spacing, but you cannot use Extend sheet to change the size.

For Responsive sheets that are not extended, the exported PDF of the sheet will be:

  • Landscape orientation: 1680 by 1120 pixels
  • Portrait orientation: 1120 by 1680 pixels

If you are using a Custom sheet size, the PDF output of the sheet will keep the custom pixel values for width and height.

Changing the Sheet size from Responsive to Custom may impact the clarity of the PDF output. If you are manually exporting a custom-sized sheet as a PDF, the best practice is:

  • Portrait orientation: values of 1680 by 1120 pixels, or a ratio of 1:1.5

  • Landscape orientation: values of 1120 by 1680 pixels, or a ratio of 1.5:1

Extended sheets and custom-sized sheets may have a lower-resolution PDF output if the sheet is too large to clearly display on a single PDF page.

  1. Change the Sheet size setting from Responsive to Custom.
  2. Enter a width for the sheet in pixels.

  3. Enter a height for the sheet in pixels.

Changing the small screen layout

By default, sheets are displayed in List view when viewed on small screens. You can change them to display as a grid. Sheets must be set to responsive layout to display as grid on small screens.

A sheet viewed on a small screen in List view (left) and Grid view (right)

Comparison of sheet list view versus grid view on smaller screens

Grid view shows a small preview of your visualizations. List view only shows the visualization titles.

  1. Under Sheet properties, go to Small screen layout.
  2. From the drop-down, select Grid view.

Extending the sheet area

You can extend the area of a sheet vertically if you need to add more visualizations than what can fit on a screen.

Information note

Downloaded extended sheets may have a lower quality PDF output if the sheet is too large to clearly display on a single PDF page.

Note the following:

  • You need to activate Extend sheet under Sheet properties.
  • Each extension adds 50% of the original sheet height.
  • If you have visualizations that scroll, this can interfere with scrolling of an extended sheet. You should leave some empty space that allows for scrolling when you design the sheet.

You can extend the sheet in two different ways:

  • Drag an object to the bottom of the sheet and drop it on the drop zone that appears.
  • Toggle Extend sheet under Sheet properties.

The sheet is now expanded by 50% of the original height. You can scroll vertically in the sheet to access all content.

Adding actions to sheets

You can add actions to sheets that trigger when users navigate to those sheets. For example, you could automatically clear selections in the app when users navigate to a particular sheet.

For more information, see Adding actions to sheets.

Adding a background color or image

You can customize the background of a sheet. You can chose a specific background color, or color by expression. Any image in the media library can be set as a background. The image can be positioned and resized so it does not fill the entire background.

The following formats are supported: .png, .jpg, .jpeg, and .gif. If you use a .gif, it can be animated or static.

Qlik Cloud Government note

Qlik Sense Enterprise SaaS - Government (US) does not support background images or colors in sheets.

  1. Open the sheet in Edit mode.
  2. Turn on Advanced options.
  3. Under Sheet properties, click Styling.
  4. Set Background to Custom. The default is Auto.
  5. Background color:

    • Single color: Choose a color using the color picker.

    • By expression: Set a color using a user-defined expression. For more information, see Color by expression.

  6. Background image: Select Image from media library. The default is None.
  7. Click Image on the default thumbnail.

    The Media library opens.

  8. Click on a folder in the media library, for example In app or Default. You can also choose to Upload media, if the image you want is not already in the media library.

  9. Select the image you want to use and click Insert.
  10. Use the drop down to change the size of your image:
    • Original size
    • Always fit
    • Fit to width
    • Fit to height
    • Stretch to fit
    • Always fill
  11. Under Position, you can change the alignment of the image. For example, the image can be centered on the sheet, or in the top-right corner.

The image and background color you selected is now visible on the sheet.

Sheet in Edit mode, with a background image set on the left

A sheet in Edit mode. A decorative background image has been set to fill the left side of the sheet.

Copying, replacing and moving items on sheets

You can copy, replace, and move items on a sheet and between sheets. You can do this in the following ways:

  • By right-clicking and selecting Cut, Copy and Paste.
  • With the keyboard shortcuts Ctrl+C, Ctrl+X and Ctrl+V.
  • Using the edit bar on the sheet (Cut, Copy and Paste). (Advanced options)

Duplicating a sheet

You can duplicate any sheet, regardless of whether it is a sheet that belongs to the app or a sheet you have created yourself. The purpose of duplicating sheets is to save time by reusing content, and to allow you to modify the duplicate so that it fits your needs better.A duplicated sheet contains the same visualizations as the original sheet, and is linked to the same master items. The duplicated sheet is a standalone sheet with no connection to the original sheet. Duplicated sheets appear under My own in app overview and in Sheets in the assets panel.

You can duplicate a sheet in the following ways:

  • Click Duplicate in the shortcut menu of a sheet in the app overview or in the sheet navigator.
  • Click Duplicate sheet in the global menu in the app overview or in sheet view.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!