topic Re: Visually separate 2 dimensions in chart in QlikView

Visually separate 2 dimensions in chart

Anonymous — Wed, 12 Mar 2014 15:28:13 GMT

Hi,

Does anyone know a way to visually separate the values of 2 dimensions in a bar chart, just like excel...

Instead of this in QV (it's not really clear)

Re: Visually separate 2 dimensions in chart

datanibbler — Wed, 12 Mar 2014 15:31:44 GMT

Hi Oscar,

basically, just like that: On the "axes" tab of the dialog, you can select to have each of your dimensions

- horizontally

- vertically or

- diagonal

QlikView will separate these vertically. You might have to play around a bit with the different "areas" inside your charting_area - press Ctrl+Shift in the area and you'll see them as red squares.

HTH

Best regards,

DataNibbler

Re: Visually separate 2 dimensions in chart

Anonymous — Wed, 12 Mar 2014 15:38:44 GMT

There just one chart area when I press ctrl+shift, and I already have one dimension in diagonal one horizontal, as seen in the image

Re: Visually separate 2 dimensions in chart

Gysbert_Wassenaar — Wed, 12 Mar 2014 15:43:46 GMT

Perhaps changing the orientation is an option:

Re: Visually separate 2 dimensions in chart

Anonymous — Wed, 12 Mar 2014 20:04:51 GMT

Or playing with the bar settings in presentation tab may help to create more distance between the bars. another thing you could do is limit the number of dimensions displayed and provide a scroll bar and may be sort descending as well.