My colleague Barry Harmsen on the QlikFix blog recently published some cool QV animations. Barry is the kid who’s math homework I copied because I was too busy playing volleyball.
Barry’s post referenced the work of Hans Rosling and gapminder.org. Hans Rosling is one of my data visualization heroes and I use Mr Rosling’s work as demonstration material when I teach Qlikview, particularly his widely viewed “Health and Wealth of Nations” time series animation.
Inevitably, after viewing “Health and Wealth of Nations” my students would ask “Can Qlikview do that?”. My answer used to be “I’m not sure”, but some time back I set out to recreate the same animation in QV. So the answer is now “yes”, but ironically, I haven’t had a student ask since I developed it. I have to wear an anticipatory grin and prompt the students with “Do you think Qlikvew can do that?”.
For the record, here’s the QV version of Gapminder’s “Health and Wealth of Nations”. You can download a working QVW that includes the animation here. Click the green play button and watch it march through the years from 1800 to 2009.
Rob,
Really like the visually accurate recretion of the GapMinder visuals.
I did something similar a few years ago after seeing Hans’ presentation and created a post about it earlier in the year: http://qvdesign.wordpress.com/2012/01/19/gapminder-org-replication-of-un-data-a-la-mr-hans-rosling/
I also included a few additional metrics to compare – such as CO2 Emmisions, all based on other freely available UN datasets.
Like you I use this chart to show the power of Qlikview and Scatter charts to get to information that otherwise wouldn’t be readily apparent in the data.
All the best,
Matt
@QlikviewBI
Nice work Matt! I’ve added your site to my blogroll.
-Rob
Hi Rob,
My high school math teacher would be very surprised to see me described as the kid whose homework got copied. I may have to forward him this post 😉
Excellent job on the Gapminder animation. I too have been asked the “Can QlikView do Gapminder?” question more than once, so I guess now’s my chance to copy some of your work 😉
Cheers,
Barry
This comment has been removed by the author.
Cool! I was blown away with Hans’ Rosling’s presentation and seeing it in Qlikview is equally amazing.
Question though, can we replicate the “trail” function in Gapminder in Qlikview? (where the dot leaves a trail as it moves to show where it has been) My guess is not – not yet at least.