Bar chart

prabhas277 — Fri, 22 Jan 2016 06:05:06 GMT

Hi,

I have bar chart in that the values from 1 to 100 if suddenly the values are increse then auto scaling is possible in qlikview?

Re: Bar chart

Chanty4u — Fri, 22 Jan 2016 06:17:27 GMT

try lik dis,

You could play with the Axes' Scales' Static Min/Max.

Go to Chart Properties > Axes > Scale, check the static min and static max and use these formulas:

Y Axis Static Min = min(aggr(avg ([X_Axis]), Dim))

X Axis Static Max = max(aggr(avg ([X_Axis]), Dim))

Y Axis Static Min = min(aggr(avg ([Y_Axis]), Dim))

Y Axis Static Max = max(aggr(avg ([Y_Axis]), Dim))