Structuring an app using sheets

Sheets provide a way of structuring your ideas and purposes for your app. When you create an empty app, it is good practice to first build a structure of empty sheets, where each sheet represents an idea or a goal. This will give you, and others who you will share your app with, a good overview of the app.

For example, let us say that you want an overview of your business's key metrics, view sales and margins by state, region and product, and also sales by city and salesperson. Instead of having all this information in one place, you could structure it by having one sheet for each of these purposes.

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 one or several sheets.

The selections that you make affect visualizations regardless of which sheets they are located 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 to the app from the app overview or from the sheet navigator.

Tip: You access the sheet navigator from the sheet view by clicking 4 in the toolbar.

Do the following:

  1. From the app overview, click 4 to view the sheets.
  2. Click P or 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.

Extending the sheet area

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

Before starting

Note the following:

  • You need to activate Extend sheet in the 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. It can be helpful to leave some empty space that allows for scrolling when you design the sheet.

You can extend the sheet in two different ways:

Do the following:

  • Drag an object to the bottom of the sheet and drop it on the drop zone that appears.
  • Click on the button Extend sheet.

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

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 enables you to ensure your dashboard will be presented to users exactly as you create them, with no adjustments for responsiveness. You can set the height and width of a sheet anywhere between 300 pixels and 4,000 pixels.

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

Note:

When a custom sheet is exported, the exported sheet is exported as a Responsive sheet.

For optimal default sheet thumbnails, keep your custom size ratio to 8:5 (width:height).

Do the following:

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

    The sheet changes to the new width.

  3. Enter a height for the sheet in pixels.

    The sheet changes to the new height.

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.

Do the following:

  • Change the Grid spacing setting in sheet properties from Wide (the default option) to Medium or Narrow.

The sheet grid is now more dense and the grid squares are smaller.

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.

Do the following:

  1. In the app overview, click 4 to view the sheets.
  2. Do one of the following:
    • If you are in grid view, ì, click the sheet title followed by clicking @.
    • If you are in list view, î, click @.
  3. Edit Title and Description.
  4. Click outside the text area.
The changes you made are saved.
Tip: You can also change a sheet’s title and description in the properties panel.

Using a dynamic sheet title

You can also 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.

Changing the thumbnail of a sheet

You can replace the default thumbnail of a sheet with another thumbnail, to make it easier to distinguish between sheets in the app overview and in the sheet navigator. You can use one of the default images, or an image of your own.

Before starting

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 an unpublished sheet.

Do the following:

  1. In the app overview, click 4 to view the sheets.
  2. Do one of the following:
    • If you are in grid view, ì, click the sheet title followed by clicking @.
    • If you are in list view, î, click @.
  3. Click 0 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 m to stop editing.

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

Tip: You can also change a sheet’s thumbnail in the sheet navigator at the top right or in the properties panel.

The following formats are supported: .png, .jpg, .jpeg, and .gif.

For Qlik Sense: You can upload images to the In app folder in the media library. You need to use the Qlik Management Console to upload images to the default folder.

For Qlik Sense Desktop: You can place images in the following folder on your computer: C:\Users\<user>\Documents\Qlik\Sense\Content\Default. Images will be available in the default folder in the media library. When moving an app between installations, the images that you use in the app are saved in the qvf file together with the app. When you open the app in a new location, for example Qlik Sense Cloud, the images will be in the In app folder in the media library for the app.

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

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:

  • Using the edit bar on the sheet (µ, and ).
  • Using the shortcut menu options Cut, Copy and Paste (or Paste and replace).
  • With the keyboard shortcuts Ctrl+C, Ctrl+X and Ctrl+V.

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 sheets in app overview and in the sheet navigator.

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 information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?