Skip to main content Skip to complementary content

Sheet view

App developers add visualizations and other elements to sheets in an app. App consumers interact with the sheet for data analysis. App developers and app consumers can interact with Insight Advisor to generate visualizations using natural language queries.

Click Sheets in the assets panel to select and open a sheet.

Develop sheets in edit mode. Interact with sheets in analysis mode. Explore your data with Insight Advisor in Insight Advisor.

Information noteYour user interface may look different from the interface shown in the screenshots below. For example, the app creator may have hidden the toolbar or sheet header. For more information, see Hiding the toolbar and header in sheets.

Edit

Click Edit to edit a sheet.

Sheet view in edit mode

Sheet view in edit mode.

You can do the following:

  • Click Sheets to add a new sheet, or to navigate to a sheet.

  • Click Add item to add new visualizations to the sheet.

  • Drag and drop fields and master items from Assets to Properties to add data to visualizations.

  • Configure the properties for a sheet or visualization in Properties.

  • Click Advanced options to use the advanced edit mode. In the advanced edit mode, you can do the following: 

    • Click Assets to open the assets panel. Add assets to your sheet. For example, you can add a visualization to a sheet. See: Assets panel

      For assisted creation of visualizations, click Use assisted explore to use Insight Advisor. See: Creating visualizations with Insight Advisor

    • Click Properties to open the properties panel. Configure the properties for a sheet or visualization. For example, you can add dimensions and measures to a visualization. See: Properties panel

Assets panel in edit mode

In edit mode, the assets panel contains:

Assets panel in edit mode

Asset panel with Fields selected. In Fields, the field City is selected, with the field values Aarhus, Albuquerque, and Alicante selected.

In advanced edit mode, the assets panel contains:

Assets panel in advanced edit mode

Asset panel in advanced edit mode.

Fields

Fields represent the data that is available in your app. Drag a field under Data in Properties to add data to visualizations. Fields are marked with different icons to display what kind of data source they are classified as.

Icon Data type Definition
Numeric data Data containing only numeric values
Text strings Data containing text strings

Date and time

All date fields are marked with and can be expanded to use date and time attributes of the field. Date and time attributes are created automatically when you use Data manager. If you used Data load editor to load data, you need to create the date and time attributes using derived fields.

See: Date & time fields

Geographic data

All fields recognized as geopoints or geoshapes in map visualizations are marked with .

See: Loading your own map data

Additionally, right-click on fields to do the following:

Master items

Create dimensions and measures as master items that can be re-used in your app.

Some master items may have associated glossary terms. You associated terms and their definition by clicking on the master item and hovering your cursor over the term. You can click on the term to view the full glossary entry for the term.

Master item with linked term

The master measure Gross margin open showing the term for gross margin from the glossary.

See:

Properties

Configure properties for a visualization in the properties panel.

Click Properties in the toolbar of a sheet to open the properties panel. You must be in edit mode.

Click on a visualization to view the properties for the visualization.

Properties

Properties panel when visualization selected.

Depending on the visualization that you are editing, you have different options. Typically, you can do the following:

  • Add dimensions and measures and specify how they are displayed
  • Set the sorting order and sorting criteria
  • Change the way the visualization appears
  • Configure custom tooltips

See: Creating and editing visualizations

Analysis

Interact with visualizations and data in a sheet.

Sheet view in analysis mode

Sheet view in analysis mode.

You can do the following:

  • Click Assets to create and manage assets for exploration of app content. This is a different assets panel than the one you see when you are editing a sheet. For more information about the assets panel in edit mode, see Assets panel in edit mode.

  • Make selections in a visualization to explore insights based on selections. See: Exploring with selections

  • Create bookmarks based on selections. See: Bookmarking selections

  • Search your data. See: Using smart search

  • Click Insight Advisor to generate recommendations for visualizations using natural language and simple configuration options. See: Insight Advisor

Selection actions
User interface item Action
Selections - History Step back in selections.
Selections - step forward Step forward in selections.
Selections - Clear all Clear all selections.
Selection search

Open smart search to search in the entire data set.

For more information, see: Using smart search

Selections - Current Open the selections tool, which is an extension of the selections bar.

Assets panel in analysis mode

In analysis mode, click Assets to open a panel where you can create and manage the following:

To pin the assets panel open in analysis mode, click Pin assets. The assets panel can be resized by clicking and dragging the border of the assets panel.

You can make Sheets or Bookmarks full screen by clicking Full screen.

You can view Sheets as a grid or list. Sheets can also be grouped together. For more information, see Grouping sheets.

Assets panel in analysis mode

An open assets panel showing the sheets in the app.

Options menu

You can use the options menu to perform actions related to the visualization.

Options menu next to a chart

Options menu for a chart.

You can open the options menu by:

  • Right-clicking on a chart.
  • Clicking the hover menu More.

Menu options will be different depending on:

  • Whether you are editing or analyzing (viewing) charts in an app.
  • The chart type.
  • The privileges that have been assigned to you by your administrator.

Options menu for a chart with hover menu expanded

Options menu when the 'more' icon next to a chart is selected.

The menu looks different if you have touch screen mode enabled on a supported device. You can toggle touch support on and off by clicking or tapping the navigation button (Navigation) and using the toggle for Navigation.

Options

Some of the available actions you might see in the options menu include:

Actions from the options menu
Option Sheet modes Available actions
Expand Full screen Edit, analysis Expand visualization to full-screen mode.
Key driver anaylsis Key driver analysis Edit, analysis Configure a key driver analysis using a measure or compatible dimension from the chart as the target. Add other dimensions and measures as features to compare their relative influence on the target. See: Uncovering the key influencers behind your data using key driver analysis
Developer options icon Developer Edit, analysis Access the developer options for the visualization. To access this feature, add /options/developer to the URL.
Info icon Show details Analysis

Show details: See the fields and master items that make up the visualization. You can view their dependencies to see the fields that comprise them and their sources, as well as any linked glossary terms.

Details can be turned on and off for visualizations in the visualization properties panel of advanced edit mode under Appearance > General > Show details.

For more about Details, see Viewing details for visualizations.

Controls Exploration menu Analysis

Change certain visualization properties, without making selections or editing the sheet. See: Visual exploration

Exploration menu is not available for analyses.

Table View data Analysis

View the data for a visualization in a table.

View data is not available for analyses.

Share Share Analysis Share the visualization in different ways, for example as an image, a link, or an embedded object.
Alert Alerts Analysis Create an alert for the data in the visualization, or open an existing alert that is already created for it. See: Monitoring data with alerts
Mail Subscribe Analysis Subscribe to the visualization to receive automated reports indicating its current appearance and data. See: Scheduling reports with subscriptions
Analyze Monitor in activity centers Analysis Add the chart to your Qlik Cloud Analytics activity center for quicker access without opening the source app. See: Monitoring visualizations
Note Notes Analysis Access the possible actions related to notes for the visualization. Your options might include Create note with snapshot, Find notes related to this chart, and Add snapshot to note. See: Capturing and sharing insights using Notes
Storytelling Storytelling snapshots Analysis Manage the storytelling snapshots available for the chart. For example, you can Take snapshot or access the Snapshot library. See: Collecting insights for stories using snapshots
Download Download Analysis Download the visualization in different formats, such as an image, PDF, or data file.
Link Add to master items, Unlink visualization Edit Add the visualization as a master visualization so it can be reused by you and other app developers. You can also unlink the chart from an existing master visualization. See: Reusing visualizations with a master visualization
Scissors Cut, Copy Copy, Paste Paste, Paste Paste and replace Edit

Standard actions allowing copying and pasting of visualizations across sheets.

Cut, Copy, Paste, and Paste and replace are not available for analyses.

Garbage can Delete Edit Delete the visualization from the sheet.
Copy Copy style, Paste Paste style Edit Copy the custom styling for a visualization and paste it onto another visualization. See: Copying and pasting visualization styling

Download the visualization in different formats, such as an image, PDF, or data file.

Expand visualization to full-screen mode.

View the data for a visualization in a table.

Change certain visualization properties, without making selections or editing the sheet. See: Visual exploration

Insight Advisor

Click Insight Advisor to access Insight Advisor Search and Insight Advisor Analysis Types. You can ask a question in the Insights search field to generate visualizations with Insight Advisor Search.

Insight Advisor

Insight Advisor open in a sheet

For more information, see Creating visualizations with Insight Advisor.

Touch gestures in sheet view

Touch gestures
Touch gesture Action
Long-touch and release Open the shortcut menu
Long-touch a visualization Open the options menu
Swipe Scroll lists and visualizations
Pinch Zoom in or out on visualizations
Two-finger tap Select an interval in a list, table or bar chart axis
Two-finger swipe Pan a scatter plot visualization
Three-finger tap Reset the zoom level of a scatter plot visualization

Learn more

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!