Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Bar charts side by side

Hi,

I try to get something like on attached screen (Screen.png) - a few bar charts side by side, with "common scale", and I have a problem with that. If someone could help me, I would be grateful.

I set everything like on the screen. I have 4 bar charts side by side, everyone has defined Static Min and Static Max (0 and 1) in Axes tab, only first chart has numbers on scale and it looks just like on the screen.

Please, see attached QV file (it's a simpler example, only with 2 charts, but it shows what's going on).

The problem is, that if you choose another dimension (in my example file it is AnotherDimension=2), then you "turn on" some projects with longer names, and then QV changes first chart (it is lower) and scales on both charts do not match.

Is there any way to solve this?

I mean to force QV not to move X-Axis when dimension labels change?

I don't want to "Limit Legend (Characters)", because I have enough place on dashboard and whole labels are important.

Regards,

Bartek

1 Solution

Accepted Solutions
Partner
Partner

Re: Bar charts side by side

when on the chart, hold down Control and Shift and adjust the axis space as required to match the other chart. If you do so, QV will not change it again automatically.

See attached

9 Replies
mov
Esteemed Contributor III

Re: Bar charts side by side

Try Trellis.  Add Country as the first dimension, and use it for Trellis.  Remove set from expression.

manojkvrajan
Contributor III

Re: Bar charts side by side

Bartłomiej - It is not possible to stick to the x-axis without trimming the # of characters due to the default properties of Charts.However, you can switch to the '-' view if you think it is possible to get the dimensions displayed in one chart managing the real estate.

ChartProperties.PNG

Not applicable

Re: Bar charts side by side

I tried to do it using Trellis, but I couldn't get proper effect.

In my application I have more than 10 projects for every country and I turned on X-Axis Scrollbar - on trellis I can't do it.

Also, when I turned on Trellis on my example app, it looked awfully - charts are very small, and everyone has all ProjectNames on it (half is empty, becouse there are from other country).

I must get something like on the screen from my question-post - that is the requirement, and I can't do it using Trellis...

Not applicable

Re: Bar charts side by side

Thanks, but "-" view is completely unreadable. Like on the screen, bars are thin (and they have to be) but ProjectNames are very long. If I could "wrap" this dimension labels I could try to go this way, but I think it is also not possible.

mov
Esteemed Contributor III

Re: Bar charts side by side

The best I was able to come up with is to standardize the length.  Say, the max length is 30, so if the actual length is 15 - add 14 spaces and a dot at the end (all spaces don't work as you'd like them).

mov
Esteemed Contributor III

Re: Bar charts side by side

Correction:

Previously I tried adding space after the text - but it looks much better this way, no dots needed:

='                         ' & ProjectName

Partner
Partner

Re: Bar charts side by side

when on the chart, hold down Control and Shift and adjust the axis space as required to match the other chart. If you do so, QV will not change it again automatically.

See attached

mov
Esteemed Contributor III

Re: Bar charts side by side

Yes, good idea.  In your example, it should be moved up on the right chart rather than down on the left, because the whole names must be visible.

Not applicable

Re: Bar charts side by side

Works great, thank you very much