topic Re: bar charts without dimension in QlikView

bar charts without dimension

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: bar charts without dimension

Fri, 04 Nov 2016 16:59:56 GMT

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

Re: bar charts without dimension

rupamjyotidas — Fri, 04 Nov 2016 17:15:15 GMT

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

Inline tables would be faster.

Re: bar charts without dimension

Anonymous — Fri, 04 Nov 2016 17:17:31 GMT

why don't you use just 3 expressions?

then disable the legend

and it looks like that:

then uncheck "show title in chart"

result:

Re: bar charts without dimension

neelamsaroha157 — Fri, 04 Nov 2016 17:38:18 GMT

You can go with bennettsc2

idea or you can try this expression

Re: bar charts without dimension

Fri, 04 Nov 2016 17:48:12 GMT

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!!!!

Re: bar charts without dimension

Sat, 05 Nov 2016 00:36:00 GMT

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