Calendar Heatmap QlikView Extension (D3CalendarView)

By Stefan Walther Comments closed
This entry was posted in Extensions

I have recently published a free calendar heatmap extension to compare values on a day-per-day basis over a long period of time (several years). The extension is developed using D3 and an existing visualization called “Calendar View” by Mike Bostok.

The data passed to the extension is displayed in a diverging color scale. The values are visualized as colored cells per day. Days are arranged into columns by week, then grouped by month and years.

Screenshots

Example 1 - Displaying Historical Dow Jones Data

Example 2 - Visualizing U.S. Commercial Flights

D3CalendarView Extension - Configuration Dialog

Usage Scenarios

There are several scenarios where using this extension seems to be a helpful kind of visualization:

  • Comparing changes of stock exchange prices
  • Making out of stock trends visible
  • etc.

Download, Configuration & Source Code

The source code, a demo-application and the .qar files are published on GitHub, where you will also find a short description how to configure the extension.

GitHub-Repository to post issues, fork the source-code, etc.:

Possibly related posts:

  1. D3 Bullet Charts / BulletGraph Object Extension
    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...
  2. SlopeGraph for QlikView (D3SlopeGraph QlikView Extension)
    Edward Tufte's slopegraph brought to QlikView as a solution using QlikView's extension concept and D3....
  3. Plea for Open Source Development in the QlikView World
    To be honest, I’m a little bit frustrated when talking about open-source development for QlikView. For quite some time I am trying to share as much content as possible and the response/feedback is little. For...
Bookmark and Share
Published: December 30, 2013
and tagged , , , . Bookmark the permalink. Both comments and trackbacks are currently closed.

9 Comments

  1. Bas van Reeuwijk
    Posted January 2, 2014 at 09:32 | Permalink

    Cool extension Walther!

    I’m going to try this one out for a few projects. Would also be good combined with comparative analysis.

  2. Jitesh
    Posted January 8, 2014 at 09:26 | Permalink

    Hi,

    Great extension! I was trying to get this into Extensions for sometime now but wasn’t able to successfully do it.
    Surely will learn a lot from this.

    One doubt :
    When I hover the mouse over the extension, it shows a “console undefined” error.
    Would it be possible for you to help me assess why that would be happening?
    Screenshot of the error : http://postimg.org/image/81rn7mlb1/

    Thanks a lot !
    Jitesh

  3. Jochem
    Posted February 9, 2014 at 21:26 | Permalink

    When i select one day i get error on line 657 character 5
    it is not able to retrieve the value of property length

    http://qlikview/QvAjaxZfc/QvsViewClient.aspx?public=only&name=Extensions/D3CalendarView/lib/js/QvExtensionFramework2.js

    I installed version 1.0.1, the above error was fixed with this release!

    Hop to hear from you.

  4. Stefan Bäckstrand
    Posted March 5, 2014 at 08:48 | Permalink

    Hi Stefan!

    Is there a way in this extension to have the first row represent Monday instead of Sunday? I guess that is a cultural difference in how we look at dates.

    • Stefan Walther
      Posted March 16, 2014 at 09:54 | Permalink

      Hi Stefan,

      there is not such possibility in this extension but could probably quite easily achieve … I will have to have a look into the code and hopefully send you an update 😉

      Regards
      Stefan

  5. T Maher
    Posted July 10, 2014 at 11:05 | Permalink

    Hi,

    This is a great extension!!!!!! Is it possible to toggle the display to show weeks and months too??

    Many thanks,

    T Maher