Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
christian77
Partner - Specialist
Partner - Specialist

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

1 Solution

Accepted Solutions
Not applicable

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
Not applicable

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

christian77
Partner - Specialist
Partner - Specialist
Author

Perfect!!!

Why I didn't see that before?

Well, that's why there is a community.

Thanks a lot Kai.

Not applicable

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