How to create an External Report from QlikView

This article will show you how to create an External Report that is linked to a report from your Qlik server.

1. Access New > External Report > Qlik View

The New External Report screen opens. Provide the following information:

  1. Give your new External Report a Name
  2. Report Type: If there is no required Report Type in the list, click the Plus (+) button and create a new one.
  3. Define whether you want report content to be updated manually or automatically. In case you choose Automatic Collection, define the following settings:
    • Define the Report Image Trigger from drop-down list
    • Select the Plugin Connection Profile you have created for Qlik View. For more details refer to: Establish Connectivity to QlikView
    • Report: Select a required workbook available from the selected connection profile
  4. Click Next: define details to proceed with Report creation.

2. Full Editor displays the Images and Links tab

  1. Choose whether to  Show report in the Metric Insights 'Viewer' or in an 'external web page'
  2. The External Report URL will be generated automatically based on your other inputs
  3. Collect image
  4. Enable & Publish

NOTE: If you chose 'Show report in External Web Page' in Step 1, you will not see your new report in the Metric Insights viewer when you are finished. If you want to see your new report, you can go to the Homepage and click the tile for your new Report. Alternatively, you can open the Elements List under the Admin menu on any page.

3. Dimensioned Report - using specific set of selections

This section describes how to configure your External Report to show selected values in your QlikView dashboard.

3.1. QlikView dashboard with selected values

In this example, the chart is displayed for Canada in the country filter.

3.2. Dimensioned External Report - Set dimension

Go to the External Report Editor > Info tab and set the Dimension with the value that contains the Selection Values used in your QlikView dashboard.

In this example, the 'Country' Dimension contains the same dimension values as Country filters used in Qlik View. The dimension values are:

  • Australia
  • Canada
  • France
  • Germany
  • Russia
  • Spain
  • United Kingdom
  • United States

3.3. Dimensioned External Report - Set filter value

Once you made this External Report dimensioned, a new field has been added to the External Report Editor > Configuration tab: the Filter field. Set the filter value that will control the selection for the chart in QlikView.

Now you can choose the Preview dimension Value. Click Collect Image. The Data Collection Parameters pop-up opens.

Select the Dimension value to be shown as the Preview and click Select.

Save your settings.

3.4. Dimensioned External Report - Result

3.5. Dimensioned External Report on the Homepage

Once published, the Metric Insights External Report will collect the images for each Dimension value, and when clicked, the live Qlik View dashboard with the selected value will be displayed.


Add your comment

E-Mail me when someone replies to this comment