Visual FX in QlikView

By Barry Harmsen

Today’s post comes to you straight from the Department of Useless-But-Fun Stuff.

Many people have seen Hans Rosling’s informative (and very entertaining) presentations in which he uses his Gapminder software to present data in animated scatter plots. With the Animate Dimension function, QlikView offers similar functionality to create animated charts.

Unfortunately, as many have discovered, animating charts in QlikView does not immediately make them informative or entertaining. In fact, the opposite is quite often the case; boring data is presented in an animated form and becomes even more tedious.

Curious to see if I could create an animated chart that, while maybe not informative, at least looks pretty, I decided to create a chart based on Lissajous curves. You can see the result, which uses a standard scatter plot, in the video below. The video contains cheesy music, so check the volume level before pressing play.


Of course, this chart lacks any practical application, but I find that it does look quite cool. Incidentally, this is also the only caseĀ  in which the use of shiny spheres in a scatter plot is permissible. Should you want to play around with the app, it can be downloaded below.

Download the QlikView Animated Lissajous Curve app

About The Author

Barry Harmsen

Hi there, I'm Barry and I'm an independent Business Intelligence Consultant based in the Netherlands. Originally from a background of 'traditional' Data Warehousing, Business Intelligence and Performance Management, for the past few years I have been specializing in QlikView and a more user-centric form of BI. I have done numerous QlikView implementations in many different roles and industries. In 2012 I co-authored the book QlikView 11 for Developers. You can follow me on Twitter at @meneerharmsen.

14 Comments

  • 1
    July 24, 2012 - 09:11 | Permalink

    Fantastic! You have left us in awe! The QT Spain team sends you a great congrats!

  • 2
    July 24, 2012 - 12:08 | Permalink

    Very nicely done!

  • 3
    July 24, 2012 - 21:27 | Permalink

    This is very cool! Well done, Barry!

  • 4
    July 25, 2012 - 16:21 | Permalink

    Awesome work Barry !!

  • 5
    Aadil
    July 25, 2012 - 16:21 | Permalink

    Brilliantly done… Hats off to you…

  • 6
    July 26, 2012 - 16:29 | Permalink

    Excellent work!

    Though the soundtrack sounds like a 1980s C64 video game! ;-)

    Stephen

  • 8
    Rob Wunderlich
    August 2, 2012 - 01:35 | Permalink

    Nicely done Barry!

  • 9
    Dror
    August 3, 2012 - 00:18 | Permalink

    Cool! uitstekend gedaan!!

  • 10
    Rob Wunderlich
    August 8, 2012 - 05:24 | Permalink

    HI Barry,

    Fun stuff! It inspired me to post on Hans Rosling’s work on my blog:
    http://qlikviewnotes.blogspot.com/2012/08/animated-charts.html

    Thanks for the homework help :)

    -Rob

  • 11
    Giulio Valeri
    October 20, 2012 - 15:32 | Permalink

    Really cool!

    A good way to discover the “flexibility” of Qlikview…

    Compliments!

    Giulio

  • 12
    November 6, 2013 - 16:23 | Permalink

    prosaic question, but how did you change the colour of the animation slider?

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

    Read previous post:
    QlikView Extension tutorials, documentation and examples

    We now offer monthly live online training on QlikView 11 extensions: Check the course page for upcoming dates QlikView Extensions...

    Close