Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

Bars on chart do not line up

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.

8 Replies
Clever_Anjos
Employee
Employee

would you mind sharing a sample of your qvw?

rittermd
Master
Master
Author

Here is the file

Clever_Anjos
Employee
Employee

Downloadind and checking

"Measure Detail" bar char?

Clever_Anjos
Employee
Employee

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

Capturar.PNG

rittermd
Master
Master
Author

yes

NickHoff
Specialist
Specialist

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.

MarcoWedel

Hi,

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

QlikCommunity_Thread_149639_Pic1.JPG

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:

QlikCommunity_Thread_149639_Pic2.JPG

QlikCommunity_Thread_149639_Pic3.JPG

QlikCommunity_Thread_149639_Pic4.JPG

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

QlikCommunity_Thread_149639_Pic2.JPG

hope this helps

regards

Marco

rittermd
Master
Master
Author

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.