topic Re: Keeping zero at the center of a bar chart in QlikView

Keeping zero at the center of a bar chart

paulm — Wed, 01 Apr 2015 20:25:26 GMT

HI,

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?

Hoping there is a check box I have missed

Thanks
Paul

Re: Keeping zero at the center of a bar chart

ramoncova06 — Wed, 01 Apr 2015 20:37:20 GMT

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

Re: Keeping zero at the center of a bar chart

ramoncova06 — Wed, 01 Apr 2015 20:38:52 GMT

didn't read the whole thing before I jumped the gun

one option is to create a variable for your max value, that way qlikview keeps it in cache and does not create an overhead

Re: Keeping zero at the center of a bar chart

fred_s — Wed, 01 Apr 2015 21:18:27 GMT

I guess not, but maybe Trellis is an option (Dimension > button Trellis bottom left).

At least it uses the same scales over all Charts.

Grtz Fred