Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Bar Chart Scale

Hi.

I have a problem with the chart shown below. 1st bar is the Actual result. Last bar is the comparison bar, and it changes with the buttons on top. Other bars are the dimensioned difference between 1st and last bar.

My problem is: Users don’t get to see clearly those differences because the bars representing them are too thin. Some of them are only a pixel high.

I’ve already tried Logarithmic Scale but it does not do anything. Also, notice the negative values. I’ve tried multiplying by 10 or 100 the middle bars, but then, values on data points are multiplied too.

What I do with paint program is change origin for 2 big bars and rescale the rest, but… how to do it in the chart?

Please send any suggestion.

Thank you.

Actual chart.

2PillarsBridge.png

Desired chart.

2PillarsBridgeDesired.png

Tags (4)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Bar Chart Scale

You could use formulas in the Static Min and Static Max boxes to change the scale dynamically based on max() and min() values.

2013-11-13_12h47_00.png

View solution in original post

3 Replies
Highlighted
Not applicable

Re: Bar Chart Scale

You could use formulas in the Static Min and Static Max boxes to change the scale dynamically based on max() and min() values.

2013-11-13_12h47_00.png

View solution in original post

Highlighted
Partner
Partner

Re: Bar Chart Scale

Perfect!!!

Why I didn't see that before?

Well, that's why there is a community.

Thanks a lot Kai.

Not applicable

Re: Bar Chart Scale

You can change the "Position" property in the Axes sheet of the graphic properties and asign diferent "Static Max" values.

ActualAndOthers.JPG.jpgComparisonBar.JPG.jpg