Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I attended the Qlikview 10 Launch in London on Tuesday (all very interesting) but one of the brief 'new features' that was mentioned was creating multiple value dial charts through overlaying and this got me to thinking that that could be done in QV9. So below are the result of my experiments with QV9 and 'Compound Charts' - I'm keen to see what others have come up with.
1. - Dual Value 'Heatline':
2. - 'Enhanced' Pie Chart =:
3. Various Mutli-value Dial Charts:
As mentioned all the charts are created using standard QV9. Examples can be found in the my 'Re-designed QV9 Server Monitor App' posted on the Share Qlikviews page.
I'm really keen to see what others have created as I see so many .qvw that use fantastic scripting and expressions yet completely fall down because they haven't got the visualization right.
I'm not holding these up as being the perfect charts (sure Stephen Few would have a 'Few' things to say) but I've found them useful already.
Any comments welcome.
Cheers,
Matt - Visual Analytics Ltd
matt.crowther wrote:I'm not holding these up as being the perfect charts (sure Stephen Few would have a 'Few' things to say)...
*chuckle* Yeah, I'm sure he would. But yes, overlaying charts is a reasonable technique, and one I've used. My most extreme example probably has a thirty or so objects all functioning as a "single" chart.
Unfortunately, as I went to go cut and paste it here, I saw that SR6 had broken it.
Grrr. Every upgrade. I swear every upgrade breaks that chart. So I guess this turns into a cautionary tale. Different QlikView versions make minor tweaks to how individual charts look. You rarely notice, and if you do notice it rarely makes a difference. But if you overlay charts, and they depend on exact, pixel-perfect alignment, you're asking for a headache.
Edit: OK, fixed until our next upgrade. Here it is. Nothing like what you're saying, so I'm not sure how much it counts, but it's still the same idea of overlaying a bunch of objects. The main difficulty in this case was making a "straight table" of the products and events and their associated numbers line up with a couple different bar charts. So the "straight table" is simulated with a whole bunch of bar charts with nothing but labels or numbers being displayed. That way, when I select a product or event, all of the bars and numbers continue to line up (until the next upgrade).
There's a slider to control a static max for the range of number of actual days, allowing you to see change the scale to see longer and shorter durations as appropriate to the products and events that you're researching.
And yes, I think Stephen Few might have a few things to say about my chart as well. Far, far too busy to make sense of at a glance. It takes a while to get the hang of it. I don't think he's a fan of using red and green in a chart either, due to the prevalence of red/green color blindness, but I disagree. The associations of red and green are too valuable to just abandon because it doesn't work for all people, so as long as the two colors as "brown" will be distinguishable to people with color blindness, I think it's OK to use them. In this case, the red is significantly darker than the green, even if it's hard to tell that it is since your eyes are processing the color as color, instead of as light and dark. They may be equally colorful, but they're not equally dark. Actually, I'm curious if someone with red/green color blindness can verify. Is the difference in color between the bars to the left of the axis sufficiently different from the bars to the right of the axis in the Actual Days vs. Standards portion of the chart?