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.

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.

Creating a new sheet

Do the following:

1. From the app overview, click 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.

Do the following:

1. In the app overview, click 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.

Using a dynamic sheet title

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

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.

Do the following:

1. In the app overview, click 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 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  to stop editing.

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.

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.

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.

Do the following:

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.

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

Do the following:

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.

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:

Do the following:

• 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

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

Do the following:

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 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.

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 (, and ). (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.