topic Re: proportion between several bar charts in QlikView

proportion between several bar charts

dambeldor — Wed, 07 May 2014 19:55:28 GMT

Hello everyone-

I have 6 bar charts with the same dimension: Year (2009, 2010, 2011, 2012), but with different expressions.

All the bars with different result.

I want the same ratio (proportion) in all of the charts.

for example: the bar with result -2 in one chart will seem smaller than the bar with result 29 in another chart.

Is there any way to do this?

Thank you.

(see attached image)

Re: proportion between several bar charts

Anonymous — Wed, 07 May 2014 19:59:03 GMT

I Think you need to work on your scale ie.

In your chart properties ... go to axes tab and change the scale accordingly

Re: proportion between several bar charts

Greg_Williams — Wed, 07 May 2014 20:02:02 GMT

Is it an option to use a horizontal gauge? Perhaps this will reflect the scaling better?

Change the Min/Max/Step values for the scale in Axes tab > chart properties.

Chart percentages instead of values themselves.

...some ideas.

-Greg

Re: proportion between several bar charts

maxgro — Wed, 07 May 2014 20:05:38 GMT

you should use Static max in Axis tab; the max should be the same for every chart; you have to calculate it, I think in a similar way

rangemax(

max(aggr(expr1, year)),

max(aggr(expr2, year)),

.....................

) * 1.1

but in your case I suppose is useless because you have big differences in expression values (starting from 2 to 200000), so there is no way to find a common max (some bars would be too small to see it; perhaps with a log scale)

Re: proportion between several bar charts

dambeldor — Thu, 08 May 2014 11:57:52 GMT

Thank you.

helped me very much .

Re: proportion between several bar charts

dambeldor — Thu, 08 May 2014 11:59:05 GMT

Thank you very much helped me.

Re: proportion between several bar charts

dambeldor — Thu, 08 May 2014 12:01:34 GMT

Thank you .

helped me very much . thanks for the detail .

(and you were right about the differences in expression values)