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

  1. Stefano
    Posted August 2, 2013 at 17:08 | Permalink

    Hi Stefan,
    do you think is possible to show entire “child” documents in different pages and force some filters from the master document?

    Thanks

  2. Jubair
    Posted September 26, 2013 at 12:35 | Permalink

    Nice Article.Yeah This clearly gives complete explanation on how to combine objects from multiple qlikview documents into a single dashboard.The chart is helpful for giving step-by-step explanation.

    Regards,
    Jubair.
    QlikView Dashboard

  3. Mike
    Posted October 17, 2013 at 16:31 | Permalink

    Afternoon Stephan,

    Great article once more.

    Are there any licensing restrictions if implementing a solution like this? So would all users be able to use this document no matter what license they had?

    Cheers

    Mike

    • Posted November 16, 2013 at 17:43 | Permalink

      If you are using a Session CAL or Named CAL there are no license restrictions, if you are using Document CALs you will certainly need a Document CAL per user & document.

      Regards
      Stefan

  4. Simon
    Posted December 16, 2013 at 17:17 | Permalink

    Hi Stefan

    It is possible to apply a theme?

    Regards
    Simon

    • Posted December 23, 2013 at 20:02 | Permalink

      No, the style of the original object will be used.

      Regards
      Stefan

  5. Simon
    Posted December 21, 2013 at 15:22 | Permalink

    Hi Stefan

    Is there a way for an object brought in by webpage viewer v2, to change the background colour? I have tried to apply changes in the original document or in the target document via the object properties but it always defaults to white with the webpage viewer v2.

    Also what needs to be done to turn on the web viewer for a document in AccessPoint?

    Regards
    Simon

  6. Christian Lindholm
    Posted June 18, 2014 at 14:01 | Permalink

    Hi Stefan,

    Thank you for the updated Web Page Viewer. For most parts it works like a charm and helps us develop certain dashboards a lot faster. Have you ever stumbled on a problem where WebView (in QVDesktop) gives the error “your browser does not support xmldocument objects” when the URL is pointing to the QlikView server in the intranet (but not when the URL is pointing to a public url.

    BR,
    -Christian