Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

dambeldor
New Contributor

proportion between several bar charts

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)

1 Solution

Accepted Solutions
Employee
Employee

Re: proportion between several bar charts

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

6 Replies
srikanthsri1
Valued Contributor

Re: proportion between several bar charts

I Think you need to work on your scale ie.

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

Employee
Employee

Re: proportion between several bar charts

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

MVP
MVP

Re: proportion between several bar charts

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)

dambeldor
New Contributor

Re: proportion between several bar charts

Thank you.

helped me very much .

dambeldor
New Contributor

Re: proportion between several bar charts

Thank you very much helped me.

dambeldor
New Contributor

Re: proportion between several bar charts

Thank you .

helped me very much . thanks for the detail .

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

Community Browser