D3 Bullet Charts / BulletGraph Object Extension

By Stefan Walther Comments closed
This entry was posted in Extensions

If you install QlikView you’ll find an extension example called “Bullet Chart” with a basic implementation to integrate bullet charts in QlikView.

This results into a basic bullet chart but without a description and sub-title of the KPI, furthermore if you want to add a series of KPIs you have to create and configure several instances of the “Bullet Chart” extension.

While this kind of visualization (based on a concept created by Stephen Few) is quite famous this extension here offers some more functionality based on a piece of code I have found on bl.ocks.org.

Screenshots of the D3BulletCharts Extension

Adding the D3BulletCharts extension:

The D3BulletCharts extension in action:

Configuration:

Compatibility

This QlikView Object Extension is only developed and tested with QlikView 11 SR2 or higher.

Download

Source Code, .qar file and a sample application can be downloaded from GitHub.
The demo application also includes a sample how the data has to be structured in the QlikView data model to be used by this extension.

Issues

Please post issues with the extension on GitHub.

Possibly related posts:

  1. QlikView AutoRefresh Document Extension
    I have uploaded a QlikView Document Extension which enables you to add the ability to a QlikView application that its UI will be refreshed automatically every X seconds. I have developed this extension some months...
  2. QlikView Extension – D3 Animated Scatter Chart
    "Animated Scatter Chart" is a QlikView Charting Extension based on the excellent charting library D3. This chart can be used to better visualize the transition of two KPIs over time....
  3. Formatting QlikView Data the Web Way (qTemplate Object Extension)
    I recently came across some projects with some special layout requirements. While it would certainly be possible to create a separate QlikView extension for every requirement I wanted to find a more generic an reusable...
Bookmark and Share
Published: November 18, 2013
and tagged , , . Bookmark the permalink. Both comments and trackbacks are currently closed.

10 Comments

  1. Jason Atkinson
    Posted December 10, 2013 at 12:01 | Permalink

    Hi Stefan,
    I really like these bullet charts. However I have a couple of issues which I hope you can help me with:
    1. The bullet chart only seems to display integers. For example the chart shows on the axis – 0, 0.5, 1.0, 1.5, 2.0, 2.5. However if the result of the expression is 2.2, the bar will only indicate 2.0. If the result is 1.9, the bar will show 1. Do you have any ideas?
    2. How can you change the bar colour based on if a certain criteria has been reached. For example – the bar should be red if the result is below the Target, green if the value is above the target.
    Regards,

    Jason Atkinson

  2. Niklas Hedborg
    Posted February 11, 2014 at 17:41 | Permalink

    Hi,

    I am very happy to have found your web site and extensions and find e.g. your WebPageViewer2_Latest.qar very useful for management dashboards. Also a big user of your IF-statement creator.

    Installing this Bullet Chart extension was not working for me though.

    I am on Windows 8.1 and Windows 2012 with IE 11 and get the same error message on both environments:

    “Invalid archive. In total 0 files in 0 directories were installed”.

    Also tried D3SlopeGraph_Latest.qar, but that gave the same error message.

    Regarding QV I know upgraded to QV 11.2 SR 5, but that did not help either.

    Kind regards

    Niklas

    • Stefan Walther
      Posted February 18, 2014 at 06:41 | Permalink

      Hi Niklas,

      maybe you can try the following:

      – change the file extension from .qar to .zip
      – Unzip it to the folder “D3BulletCharts”
      – Copy the folder to C:\Users\%USERNAME%\AppData\Local\QlikTech\QlikView\Extensions\Objects
      – Re-Open QlikView Desktop

      Does this work?

      Regards
      Stefan

      • Niklas Hedborg
        Posted February 18, 2014 at 09:30 | Permalink

        Hi,

        Unfortunately seems to be my lack of knowledge of how GitHub works.

        I right-clicked on the following link:
        https://github.com/stefanwalther/D3BulletCharts/blob/master/qar/D3BulletCharts_v1.0.1.qar

        Saved that down as “D3BulletCharts_v1.0.1.qar”, which did not work at all to extract.

        When I now instead followed the link and then left clicked on “View RAW” it allowed me to download a working copy of the .qar-file.

        Looks fantastic in my dashboard now.

        Thanks a lot for your kind response and useful solutions.

        Kind regards

        Niklas

  3. Nanette
    Posted April 6, 2014 at 16:13 | Permalink

    I am running Qlikview 11 SR5 personal edition. I am trying to install the Bullet Chart Extension. First I downloaded the D3 Bullet Chart Extension and it appeared to install correctly into the I click on the .qar file and it says everything is installed, and the directory appears in the /appdata/local/qliktech/qlikview/extension/objects folder. however, it does not appear on the Settings>document properties>extensions list of available extensions, nor is a bullet chart an option on create sheet object>charts.
    I then found the bullet chart extension is released with the product. I installed this .qar file and deleted the D3 directory, but, again, I can’t find the bullet chart anywhere from my personal edition menus.
    What must I do to complete the installation and actually use this chart? Thanks!

  4. Kevin P.
    Posted May 28, 2014 at 22:49 | Permalink

    Hi Stefan,

    I am traveling getting this extension to work.

    I am using QlikView Desktop Client 11.20.12235.0 SR5 64-bit

    I downloaded D3BulletCharts_v1.0.1.qar and successfully installed it without errors.

    I switch to WebView and can Add New Sheet Object and can drag the D3 Bullet Charts object onto the tab.

    BUT:
    I can’t get the Properties to keep anything in Range1, Range2, etc. As soon as I close the Properties, they are erased. And the chart displays nothing. I can change the chart Caption, but that seems to be about it.

    Any ideas?

  5. Dominic
    Posted June 12, 2014 at 14:44 | Permalink

    Hi Stefan

    I’m getting javascript errors on the latest version of Qlikview – it worked OK on QV 11.2 SR2, but wont work on QV11.2 SR6 – is there an issue?

    Thanks

    Dominic

    • johnnyutah
      Posted June 14, 2014 at 06:53 | Permalink

      Same problem for me, getting the javascript errors with the version with new color schemes. what could the issue be

  6. Nasir. N
    Posted July 1, 2014 at 12:02 | Permalink

    Hi Stefan,

    I’m using the bullet chart extension with great pleasure. However, I’ld like to change the color of the numbers on the axis. Can you please tell me how this can be achieved?

    thanks!
    Nasir

  7. JFlorian
    Posted July 24, 2014 at 01:17 | Permalink

    Hi Stefan,
    I extract qar like a zip file in folder related, however when I opened demo file, qlikview show me the follow messages:

    Line 3
    Carácter 16721
    Error Object doesn’t support this property or method
    Código 0
    URL http://qlikview/QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/D3BulletCharts/lib/js/d3.v3.min.js

    Line 6
    Carácter 5
    ‘d3’ is undefined
    Código 0
    URL http://qlikview/QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/D3BulletCharts/lib/js/BulletCharts.js

    Line 110
    Carácter 17
    ‘d3’ is undefined
    Código 0
    URL http://qlikview/QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/D3BulletCharts/script.js&xrfkey=gXnCNHcLr8eYUzGK

    Can you help me to work with this extension?

    Thanks in Advanced.

    -JFlorian