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.

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.

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

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 icon)

• Edit sheet

Do the following:

1. In the navigation bar, click the app name, and then click  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.

Do the following:

1. In the navigation bar, click the app name, and then click  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

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.

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.