Create External Report from QlikView
This article shows a sample of QlikView dashboard and describes how to:
- Create External Report
- Manage filters
- Collect image
- Arrange additional settings (field name in QlikView)
External Reports using the QlikView data source are developed in their editors. Filters allow to include a slice of data desired and exclude irrelevant values.
1. Sample of QlikView Dashboard
Most of the data displayed with QlikView objects can be filtered by offered criteria.
In the example below, all available filters are located to the right of the graph. The view is adjusted by means of inclusion to or exclusion from filters of the following values:
- Product Category
2. Creating External Report
To create External Report:
- Go to [+New]
- Access [External Report]
- Select QlikView to continue
- Name External Report
- Select a dimension to produce a dimensioned External Report
- Set "Category"
- Set a trigger to determine when and how t collect data
- Select a QlikView plugin connection profile
- Select a QlikView object
- [Next: Define Details] to proceed
The [Dimension by] field is set to "Not Dimensioned" by default.
3. Managing Filters
To learn how to find a filter name and alias in QlikView, see Additional Settings section.
3.1. Adding Filters
- When filters are added to External Report for the first time, they are automatically applied to all new elements associated with the used data source / sheet.
- External filters are tied to the QlikView sheets, not the Metric Insights' elements. This allows filters to be reused for multiple elements (there is no need to create new filters every time an element is created in Metric Insights).
In Configuration tab:
- Access [Manage Filters]
- [+Filter] to add filters
In the Add QlikView Filter editor:
- Select "Enter Manually"
- [+Add Value]
- Determine the value name, which must exactly match the name in the plugin dashboard
- Go to [Pencil] to access the filter editor
- Check "Display in the External Report Viewer" to the filter in Viewer
- Select "yes" for "Filter Defaults" to set the filters as default
- Select "Default Value"
Single Value and Multi-Value allow users to filter by a single value or filter by multiple values respectively. Example of filters is shown below.
In example 1, the filter is single-valued.
In example 2, the filter is multi-valued.
Single value and multi-value can be also set to filters with manually entered filter values.
In the examples above:
Example 1 (multi-valued filter) allows:
- Selecting only one value from the drop-down list, and
- Determining that a user must select a filter value
Example 2 (single-valued filter) allows:
- Selecting multiple values from the drop-down list, or
- Passing all values at once
In View, the collected image is:
- Multi-value filtered by Channel, and
- Single-value filtered for Country and Product Category
To learn how to collect images for External Reports, see this section.
3.3. Deleting Filters
To delete filters:
- Select [Manage Filters]
- Click the trash bin icon of the filter to delete it
- [OK] to confirm the intention
4. Collecting Image
- External Report created as defined above
- Filters set as desired (optionally)
In [Configuration] tab:
- Access [Collect Image] to collect the image
- [Setup Image] to set up the image size and scale it as required
5. Additional Settings
- This section describes how to retrieve a filter name and an alias (ID) from the QlikView dashboard.
- A filter alias (ID) contains letters and digits as shown below.
- In the Configuration tab, go to [View] to access the QlikView dashboard
- In the QlikView dashboard:
- Choose which filter to use, and
- Right-click on the filter name to access its Properties
- Select Properties
In Priorities, find:
- Filter alias (ID): [LB01]
- Filter name: country (case sensitive)