This article shows you some additional features and advanced functions to take Custom Report to the next level.
Search and Clear Functions in Dimensions and Measures list
- Click the magnifying glass icon to search among your Dimensions and Measures to quickly locate the search value.
- Use the Clear all selections icon located next to the Dimensions and Measures Headers to clear all selections.
Figure 1: Search and Clear
Add totals to table and pivot table
Clicking the sum icon next to a selected measure adds a new row at the top of the table displaying the sum of the selected measures (Figure 2).
Figure 2: Adding Totals
Copy a value or copy table
Copy the value under the mouse cursor by pressing Ctrl + C. A notification will confirm the copied value at the bottom of the screen.
Copy the entire data table of the current visualization if it is less than 10 000 cells. Copy table is available through the context (right-click) menu. A notification will appear at the bottom of the screen when the data is exported. Click the toast "Copy table to clipboard" to copy the table.
Note: The ability to copy table through the context menu can be disabled in the settings.
Figure 3: Copy Table to Clipboard
Export to new application
It is possible to export the current state of a selected data set to a new application. In the new application, master items will be created from your dimension and measures. In Qlik Sense Enterprise the user need to have security rights to create an app for the feature to work. For June 2018 and later releases the new app will open in Generate Insights mode that suggest charts based on the data.
Use these two steps to create a new app based on the data in your Custom Report.
1. Right-click and select export to new app. Click to open the new app which is now generated.
2. Enable generate insights and select the visualizations you would like to use with the data.
Note that the feature requires that the user has access and license to create a new application and edit it.
Export data to template
To export to new application using a template go to Settings --> Experimental settings --> Enable export to Template. This is an unsupported feature but feel free to try it out.
Export object to new sheet
To further develop an object it is possible to export any object created inside the Custom Report to a new object on a new sheet.
Note: This does required developer privileges and a professional license in Qlik Sense. Simply use the context-menu and choose Export\Export object to new sheet.
It is also possible to add the table as a master item. Click the checkbox and give the master item a proper name. The master item will be created and the new object will be linked to the master item when created on the new sheet.