Skip to main content Skip to complementary content

Styling sheets

You can customize the style of your sheet changing the title and description, adding conditions for when the sheet displays in the app and adding sheet thumbnails.

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

Hiding the toolbar and header in sheets

You can hide the toolbar and sheet header in your app. This means that these areas will not display on any sheet, for any user, regardless of permissions. Any user with Can edit rights in the app can toggle these elements on or off.

Toolbar

The toolbar is the area above the sheet that contains the following buttons:

  • Assets

  • Insight Advisor

  • Selections (shown with Selections tool icon)

  • Edit sheet

  1. In the navigation bar, click the app name, and then click Settings to open app options.
  2. Under Appearance, toggle off Show toolbar.

Sheet header

The sheet header is the area on the sheet that contains the sheet title, title image, and the sheet navigation arrows.

If you hide the sheet header, the navigation arrows move to the toolbar.

  1. In the navigation bar, click the app name, and then click Settings to open app options.
  2. Under Sheet title styling , toggle off Show sheet header.

When to use it

Advantages

Hiding the toolbar and sheet headers creates more space for charts, filter panes, and other objects.

Turning off sheet headers means that this area will not appear when you download or share sheets, send subscriptions, or generate Qlik Application Automation reports. This is helpful if you are using your sheets to create PowerPoint presentations or dashboards.

Removing the toolbar means app developers have more control over which features other users can access easily. For example, hiding the Edit sheet button might discourage other app developers from editing the app.

Disadvantages

Hiding the toolbar does not completely remove capabilities such as bookmarks, notes, Insight Advisor, or sheet editing. For example, bookmarks can still be found in the app overview. However, app consumers may think that these features are no longer available.

If you hide the toolbar and sheet header, the only way to navigate between sheets is by using keyboard shortcuts or button objects. For more information, see Keyboard navigation and shortcuts in apps and Creating buttons.

If the selections area is hidden, users may not realize that selections have been applied to the app. You may need to add filter panes to your sheets or filters to individual charts. For more information, see Creating filter panes and Applying filters to visualizations.

Examples

A sheet displaying the toolbar and sheet header. The toolbar shows Notes, Insight Advisor, current selections, and more. The sheet header contains the title image, sheet title, and navigation arrows.

A Qlik Sense sheet where the toolbar and sheet header are visible at the top.

The same sheet as above, but the toolbar is visible and the sheet header is hidden. Users can no longer see the title image, sheet title, or navigation arrows.

A Qlik Sense sheet where sheet header is hidden.

The same sheet as above, but the sheet header is visible and the toolbar is hidden. Users cannot see which selections have been applied.

A Qlik Sense sheet where sheet header is hidden.

The same sheet as above, but the header and toolbar have both been hidden.

A Qlik Sense sheet where both the toolbar and sheet header are hidden.

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.

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.

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!