bar charts without dimension

[#1]

Hi I made a bar charts without dimensions because each bar uses calculation from different table and I cannot use dimensions.

the bar chart looks find but I want to be able to put a dimension like labels below the bar charts.

so the above screenshot, A,B,C is obviously not a dimension but for the sake for explaning i just put it there. and on the right side of the chart there is a legend that I named A, B, and C. Is there any way that I can put a dimension like legend right under each bars?

Thanks!

[#2 · Accepted solution]

Hi David,

What about using an InLine table to dummy up A, B, C as a dimension similar to below:

I've attached the .qvw for the above example,

Does this help?

Thanks!

Stan

[rupamjyotidas]

You can use what Stan has suggested  or use ValueList Function and follow the same Equation as Stan.

Inline tables would be faster.

[Anonymous]

why don't you use just 3 expressions?

then disable the legend

and it looks like that:

then uncheck "show title in chart"

result:

[neelamsaroha157]

You can go with bennettsc2

idea or you can try this expression

[#6]

Hi Stan! Thank you this worked!

I just have one following question.

for each fake dimension I am going to use three expressions.

THis is to compare the three dimensions based on how each dimension can be classified.

in order to do that I want the same color coding for each dimension. but right now all the colors are different.

is there any way i can use the same color coding for each dimension so that the stacked chart can compare the components of each bars?

Thanks!!!!

[#7]

You can manually set the bar color for each expression similar to the following:

In the attached qvw the top bar is set to red and the bottom part of the bar is set to green.

Is this what you need?

Stan