topic Unaligned bars on bar chart in QlikView

Unaligned bars on bar chart

Tue, 17 Jun 2014 15:00:56 GMT

I`m having a problem with my vertical bar charts. The bars are unaligned and sometimes they are cut.

How can I solve this?

Thanks.

Re: Unaligned bars on bar chart

gmoraleswit — Tue, 17 Jun 2014 15:04:52 GMT

I think the problem is that you have negative and positive values, you van use the 'fabs' functions to get only absolute values if you want them to be aligned.

If the problem are not the values, please attached the qvw

Re: Unaligned bars on bar chart

Tue, 17 Jun 2014 15:08:48 GMT

The problem is not the horizontal alignment, but the vertical alignment. It's possible to see in the picture that the labels are not aligned with the bars, and the first bar is cut.

Re: Unaligned bars on bar chart

gmoraleswit — Tue, 17 Jun 2014 15:15:44 GMT

I see, Can you attached a qvw with an example please?

Re: Unaligned bars on bar chart

giakoum — Tue, 17 Jun 2014 15:26:53 GMT

Not easy to understand from the image, but it looks to me that both bars are sharing the same dimension, that is why the align like that. Do you have any invisible or transparent expressions?

Re: Unaligned bars on bar chart

Tue, 17 Jun 2014 15:35:02 GMT

Yes, I have created other expression to put the percentage beside the label, then I removed the flag of bar cahrt but a invisible bar yet stayed there. I solved my problem setting the flag of simble and the flag of invisible.

Thanks