Working with sheets

Organize data visualizations for your app consumers in sheets. Make it easier for them to analyze data by structuring your ideas and defining the purpose of your app.

Sheets are components of Qlik Sense apps that group and present visualizations of your app data. Visualizations are charts or other representations of app data, such as bar charts and pie charts. App consumers can use your sheets and visualizations to explore data to find insights and make discoveries.

Sheets are developed in edit mode and viewed in analyze mode. Analyze mode is the standard view of a sheet most of your app users will see. In it, users can make selections in the data that is displayed in visualizations. Selections are applied to all visualizations in the app, enabling users to explore your app's data in depth.

To learn more about selections and exploring data in visualizations, see Exploring with selections and Exploring data with visualizations .

Build sheets for your app in edit mode. When you create a 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. 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.

Click Edit sheet in an open sheet to start building a sheet. The edit mode interface helps you quickly create visualizations and lay them out in a sheet. With edit mode's smart grid, you can quickly place new visualizations beside or below a chart and drag them into their final positions. You can easily create filters in your visualizations, limiting the data that displays in the charts.

You can continue to make selections in visualizations while editing a sheet. This helps you test out your visualizations as you develop your sheets.

In edit mode, you can do the following:

• Add new charts.

• Change the sheet title.

• Edit sheet layouts.

• Add filters to your charts.

• Reload app data (if you have permission in the space).

• Add data to your app (if you have permission in the space).

• Add new sheets.

Advanced options are available when editing a sheet by turning on Advanced options. These allow you to do more complex customizations with your sheet.

If you have used previous versions of Qlik Sense, you will recognize the advanced options as the previous sheet editor. Turning on Advanced options offers all the features and properties previously available when editing sheets. Some sheet creation tasks must be done using advanced options. These include:

• Edit the sheet properties, such as description and thumbnail.

• Add a background color or image to a sheet.

• Add expressions as dimensions or measures to visualizations.

• Color visualizations by measure or expression.

• Add custom objects to a sheet.

• Setting show conditions for sheets.

• Adjust grid size and layout of a sheet.

• Add actions to a sheet.

Advanced options also offers a greater range of visualization properties for customizing and styling your visualizations. For more information, see Working with advanced options.

Permissions

Editing sheets requires that you have Professional or Full User entitlement and that you have appropriate permissions to add or edit sheets in the space the app is in. In shared spaces, you can create and edit sheets with the following permissions:

• Owner

• Can manage

• Can edit data in apps

• Can edit

In managed spaces, you can create and edit sheets with the following permissions:

• Owner

• Can manage

• Can contribute

Limitations for app content that will be shared or exported

Apps, sheets, and charts are shared and downloaded in several ways:

• Automated reporting using the Qlik Reporting Service

• Capturing and sharing insights using Notes

• Downloading app content

• Monitoring visualizations

• Scheduling reports with subscriptions

• Sharing visualizations

When you are creating and editing sheets, keep the following technical limitations in mind. If your app exceeds these limits, the above features will not work.

• Maximum number of fields in the selections: 125

• Maximum number of field values in the selections: 150,000 total field values across one or many fields

• Maximum number of alternate states: 125

  Using alternate states for comparative analysis

• Maximum number of patches: 100

  Patches are properties or styling applied in the app. For example: Adding a sort to a table column.

• Maximum number of variables: 1,100

  Using variables in expressions

• Maximum image size: 4,000 x 4,000 pixels

• Minimum image size: 5 x 5 pixels for charts and 20 x 20 pixels for sheets

• Maximum number of sheets in the app: 50 (Qlik Reporting Service only)