I have ALOT of bar charts that shows difference vs previous year/budget, which as you can guess can change from positive to negative from month to month. To keep the charts consistence through out the page I would like to keep the zero at the center of all charts, but when I leave it to QlikVIew to decide the best layout, it will remove one side of the chart if no values fall on it.
I am just asking if there is a easy way of forcing there to always be a positive and negative x-axis. I know I can add a dynamic min max static value, but the calculations are quite taxing, so prefer to not force QlikView to do the same calculation more than it has too... Can I reference the expression directly without it having to recalculate?
on axes go to static min and apply the max value/expression and multiply by -1, this will convert your max value to a negative number, and add this same max in your static max but without multiplying it