topic Re: Bars on chart do not line up in QlikView

Bars on chart do not line up

rittermd — Mon, 26 Jan 2015 23:12:42 GMT

I have a stacked bar chart and not all of the bars are the same length.

I am new to QV and have no idea what might be causing this or if there is a setting that I need to change. They should all be the same length. I don't think that I am doing anything advanced in this chart. Just one dimension and two expressions that are stacked.

Re: Bars on chart do not line up

Clever_Anjos — Mon, 26 Jan 2015 23:30:52 GMT

would you mind sharing a sample of your qvw?

Re: Bars on chart do not line up

rittermd — Tue, 27 Jan 2015 02:22:33 GMT

Here is the file

Re: Bars on chart do not line up

Clever_Anjos — Tue, 27 Jan 2015 13:54:37 GMT

Downloadind and checking

"Measure Detail" bar char?

Re: Bars on chart do not line up

Clever_Anjos — Tue, 27 Jan 2015 16:07:02 GMT

I think it´s your bar graph, right? I am noticing that you have different values, you want them always suming 100%? I´m afraid I can´t see the whole picture what you really need

Re: Bars on chart do not line up

rittermd — Tue, 27 Jan 2015 22:05:13 GMT

yes

Re: Bars on chart do not line up

NickHoff — Tue, 27 Jan 2015 22:12:32 GMT

You can hold down control while you click the chart and a red square will appear, you can adjust the way the chart sizes to your liking.

Re: Bars on chart do not line up

MarcoWedel — Tue, 27 Jan 2015 22:54:59 GMT

Hi,

your two expressions do not sum up to the same values, so the bars can't line up per se:

As you are the expert for your data, you are the one to tell what's "wrong" with your data or calculations.

However, if you just want to graphically align the bars, even if they represent different values (as they are scaled in % it might be a relative comparison anyway), you could do so like this:

Or just showing the bars relative with the numerical part of the above mentioned dual() functions:

hope this helps

regards

Marco

Re: Bars on chart do not line up

rittermd — Wed, 28 Jan 2015 13:22:01 GMT

The two bars should not add up to say 100%. They are two different calculations just being displayed for the same measure. So I don't understand why one bar would be treated differently than the rest of them.