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.
Edit
Click Edit to edit a sheet.
You can do the following:
-
Click Sheets to add a new sheet, or to navigate to a sheet.
-
Click 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:
-
Sheets: View and edit sheets in the app.
-
Bookmarks: View and edit bookmarks in the app.
-
Fields: Add data to visualizations from available fields.
-
Master items: Add data to visualizations from available master items.
In advanced edit mode, the assets panel contains:
-
Sheets: View and edit sheets in the app.
-
Bookmarks: View and edit bookmarks in the app.
-
Fields: Add data to visualizations from available fields.
-
Master items: Add data to visualizations from available master items.
-
Charts: Add visualizations to the sheet.
-
Analyses: Add analyses to the sheet.
-
Custom objects: Add custom objects to the sheet.
-
App navigation links: Add links to build on-demand apps.
-
Dynamic views: Connect a base app to a template app to use master visualizations from that app as dynamic charts in your sheets.
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 . |
Additionally, right-click on fields to do the following:
-
Create a new master dimension. See: Creating a master dimension from a field
-
Create a new master measure. See: Creating a master measure from a field
-
View field settings. See: Always one selected value
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.
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.
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
Analysis
Interact with visualizations and data in a sheet.
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
User interface item | Action |
---|---|
Step back in selections. | |
Step forward in selections. | |
Clear all selections. | |
Open smart search to search in the entire data set. For more information, see: Using smart search |
|
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:
-
Sheets: View and navigate sheets in the app. Create and group sheets.
-
Bookmarks: View and navigate bookmarks in the app. Create new bookmarks.
-
Notes: Capture and share insights.
-
Key driver analysis: Create, manage, and view key driver analyses.
Uncovering the key influencers behind your data using key driver analysis
-
Reports: Generate on-demand reports based on activated templates. This section is not visible unless at least one template has been activated for on-demand report generation.
To pin the assets panel open in analysis mode, click . 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 .
You can view Sheets as a grid or list. Sheets can also be grouped together. For more information, see Grouping sheets.
Options menu
You can use the options menu to perform actions related to the visualization.
You can open the options menu by:
- Right-clicking on a chart.
- Clicking the hover menu .
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.
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 () and using the toggle for .
Options
Some of the available actions you might see in the options menu include:
Option | Sheet modes | Available actions |
---|---|---|
Full screen | Edit, analysis | Expand visualization to full-screen mode. |
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 | Edit, analysis | Access the developer options for the visualization. To access this feature, add /options/developer to the URL. |
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. |
Exploration menu | Analysis |
Change certain visualization properties, without making selections or editing the sheet. See: Visual exploration Exploration menu is not available for analyses. |
View data | Analysis |
View the data for a visualization in a table. View data is not available for analyses. |
Share | Analysis | Share the visualization in different ways, for example as an image, a link, or an embedded object. |
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 |
Subscribe | Analysis | Subscribe to the visualization to receive automated reports indicating its current appearance and data. See: Scheduling reports with subscriptions |
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 |
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 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 | Analysis | Download the visualization in different formats, such as an image, PDF, or data file. |
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 |
Cut, Copy, 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. |
Delete | Edit | Delete the visualization from the sheet. |
Copy style, 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.
For more information, see Creating visualizations with Insight Advisor.
Touch gestures in sheet view
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 |