topic Axis in bar & line chart too poor in QlikView

Axis in bar & line chart too poor

Wed, 13 Oct 2010 13:03:07 GMT

Dear Ladies and Gentleman,

I've got issues in showing an appropriate graph to my end-users.

The lines look pretty cool. But the blue bar-chart looks poor. You can hardly see the difference between 63 and 139.

If I'm looking at a whole product-range this looks fine, but doing a deep-dive and selecting just one single product, it's poor.

Is there any possiblity to change the X-Axis to see the difference even between 67 and 139?

Thank you very much!

Axis in bar & line chart too poor

prieper — Wed, 13 Oct 2010 13:26:55 GMT

You may try a logarythmic scale, untag "force 0" to have a variable axis, artificially multiply all blue values with 100 or use trailing graphic to show steps in your curve.

HTH
Peter

Axis in bar & line chart too poor

Wed, 13 Oct 2010 13:36:07 GMT

The logarythmic scale does not look that nice.

By an artificall multiplication it might look nice, but I will end up with 10300 Units for January. This will be confusion for the end-user.

Axis in bar & line chart too poor

prieper — Wed, 13 Oct 2010 15:38:37 GMT

Think that the normal possibilities are then exhausted, You may think of overlaying a second chart (with transparent background etc), which only shows the "blue" values with it's own axis. A bit tricky to have the charts lying over each other and in the outcome very similar to multiplication with 100.

Else you have to choose a second chart.

Peter