Brilliant Qlikview Parallel Co-Ordinates Chart
It’s time for a Big Dog chart…from a Big Dog; this piece of awesomeness came via Alistair Eaves Director of Qlikview Labs and therefore Qlikview Geek Number One; it’s the Parallel Co-Ordinates Chart:
What complicated Extension Object is used to create this wonderous graphic? – none; it’s a bog standard Line Chart; in my mind that makes it all the more brilliant. This was posted to the Qlikview Community by Alistair but for some reason was removed during the recent re-vamp so many of you may well have missed it, and this certainly isn’t a chart to miss out on, it does things other charts just can’t do. I imagine you may well be looking at the above example and be thinking; ‘that’s just crazy, it’s not showing anything’ – how wrong you are; this is one of the clearest charts going; you just have to know what’s going on.
The chart is ideal for showing spreads between various positions, in my example we’re seeing Insurance Quotes and the volume at various positions; the Title of the applicant, the current Status of the Quote, what Products the Quote includes and which Month the Quote was created in, I can instantly see from the chart that the majority of my Quotes are coming from Men, they’re Inforce, spread across all products and were mostly created in May – awesome; the entire position of a business in one glance at one chart. This could of course just as easily be showing the position of Orders, Sales, Claims etc etc and can work based on a sum (eg of Sales) just as easily as counts of volume.
That’s not all; the chart is dynamic; the user can choose which fields to show on the chart, which field will drive the colour split AND despite it’s complexity it’s easily transferable due to it’s usage of generic expressions.
I’m not going to even try to explain how to build this from scratch as it’s far too complicated…but fortunately; I managed to grab a copy of it before it was removed from the Community site, it can be downloaded here: https://docs.google.com/open?id=0B0nQ9tZcY4wzMjBhNGQ4ZDctYTQ0Yi00ZjA0LWI3YTktNGUwYTE5MmI1ZjAx
As a note towards actually using this chart; not all fields are suitable to be selected as they have too many values; you’re never going to be able to show ‘CustomerID’ on here for example (not without significant pre-selections) so as I have you’ll need to make a few adjustments before setting it loose on users…and as always; tell them what it’s showing or they’ll revert to looking at a Straight Table.
This chart is the essence of what I’m trying to achieve with QVDesign; it’s a great chart that uses nothing that isn’t straight out of the Qlikview box but has to my knowledge never been readily promoted by Qliktech; and why not? – it’s beautiful, shows information in a sublime way, the only new chart from Qliktech I’ve seen in my QV Lifetime has been the Mekko Chart…ever used one?; no, me neither.
So; be brave and get it integrated into a dashboard and blow someones mind with what’s possible (I wish I’d had this when I was in Technical Pre-Sales!).
All the best,