topic Re: Chart with benchmark, how to implement dynamic min/max scale for axis in QlikView

Chart with benchmark, how to implement dynamic min/max scale for axis

Anonymous — Tue, 14 Feb 2017 14:19:30 GMT

Hello,

I have a chart with an Benchmark calculation as attached.

Due to a better view on the values I try now to implement a dynamic scale in this chart.

I found the example to set static min and static max fields using expressions that take the min/max value of an aggregation.

For example:

Min ( Aggr ( Sum ( valuefield ) , DateTimeField ))

Max ( Aggr ( Sum ( valuefield ) , DateTimeField ))

But if I try to implement this in the attached file it doesn't work?

If anyone has an advice I would be very thankful!

Many thanks and best regards

Claus

sunny_talwar — Tue, 14 Feb 2017 14:25:41 GMT

Looking to get this?

Static Min

=RangeMin(Min(Aggr(Sum({1}SALES), PERIODE, AREA)), Min(Aggr(Avg({1}SALES), PERIODE)))

Static Max

=RangeMax(Max(Aggr(Sum({1}SALES), PERIODE, AREA)), Max(Aggr(Avg({1}SALES), PERIODE)))

Anonymous — Tue, 14 Feb 2017 14:33:54 GMT

Many thanks Sunny,

this is exactly what I searched!

But for a better view on the min/max values I would use the adjusted formulas.

Best regards,

Claus

Static Min

=RangeMin(Min(Aggr(Sum({1}SALES), PERIODE, AREA)), Min(Aggr(Avg({1}SALES), PERIODE))) *0.9

Static Max

=RangeMax(Max(Aggr(Sum({1}SALES), PERIODE, AREA)), Max(Aggr(Avg({1}SALES), PERIODE))) *1.1

sunny_talwar — Tue, 14 Feb 2017 14:34:46 GMT

Awesome