Executive Dashboard: Combining Multiple QlikView Documents into a Single Dashboard

This article demonstrates how you can combine several objects from multiple QlikView applications into a single dashboard (Executive Dashboard).

Motivation

From a performance and manageability perspective it absolutely makes sense to segment your data, to split up different analysis aspects into several applications. This is the basis of QlikView’s App approach.

But at the same time it is often needed to combine results from several QlikView applications within a single dashboard. QlikView does not deliver that functionality out of the box, but fortunately integration capabilities are very strong in QlikView, so we’d just need to bring some existing integration concepts together to create an Executive Dashboard with charts / figures from multiple QlikView applications.

The Approach

The easiest approach for placing different objects from multiple QlikView objects onto a single user interface / dashboard is probably just creating a web page and using QlikView’s Mashup capabilities (see the previously posted article and the collection of examples I have published some weeks ago).

My approach for achieving the desired result was to use two different integration techniques:

  1. QlikView Mashups to reference QlikView objects from several QlikView documents
  2. Using the WebPageViewer extension (which is installed as one of the example extensions when installing QlikView Desktop)
  3. Putting several instances of the WebPageViewer extension on one sheet and reference external objects
  4. While referencing the external objects use some parameters which should be passed to these external objects to pre-select dimensions which are common in all external documents (e.g. time dimension, region, etc.)

Unfortunately this approach does not work out of the box because there is a (very little) bug in the WebPageViewer extension which does not allow to place this extension several times on a single sheet, that’s why I have created a clone of the WebPageViewer extension (called “WebPageViewer 2”) which provides a bugfix and some other minor functional additions to the extension.

The Solution & Some Screenshots

Using this modified extension it is now possible to place as many external instances of the extension onto a single sheet:

Screenshot Executive Dashboard

Limited Interactivity

Unfortunately interactivity in this dashboard is only supported partially using this approach:

  • If you change the year (field of the host document) in above displayed dashboard, the charts will refresh to show only the values for the selected years, so this works fine
  • But unfortunately I did not find an easy way to support selections within the charts and bring these selections back to the host document. So I completely prevented interaction with these charts. This is defined in the extension’s properties. If the user clicks somewhere in one of the WebPageViewer2 extensions, he will see a message that interactivity is not supported. So these charts are some kind of only “read-only”.

Message displayed if user clicks somewhere in the chart

WebPageViewer2: Property Dialog to Prevent Interaction

Benefits of this Approach

This approach can be used very dynamically, so you could also reference documents depending on selected values in your host document. This especially makes sense if you segment your data using QlikView Publisher’s “Loop and reduce” functionality:

Reference Objects Dynamically based on Selection in Host Document

Downloads

Bookmark and Share

and tagged , , . Bookmark the permalink. Both comments and trackbacks are currently closed.

9 Comments