Maximum of Bar Charts

[#1]

Hello All,

I have two bar charts and i want their scales to be dynamic and same.

i tried finding max of barchart 1 and barchart 2.

then set the static max of both to the max value obtained.

but its not working.

Please help.

thanks

[jagan]

Hi,

Please attach the sample qlikview file.

Regards,

Jagan.

[#3]

Please find attached the example.

The objective is to fnd the maximum value of Barchart 1 and Barchart2 and set the static max of both to the maximum value(in this case it is 27)

so that both barchart will be proportionate to each other.

thanks

[#4]

Hello,

Did anyone try the example?

Thanks.

[jagan]

Hi,

Can you qvw file without zipping it.

Regards,

Jagan.

[#6]

Hi,

Goto settings and go to variable overview then add a variable and set the variable definition as below

=rangemax(aggr(max(Div1/Div2),Country),aggr(max(Val1/Val2),Country))

Then use this variabe as the static max in your chart Axes.

Regards,

Sajeevan

[#7]

The file with solution is attached.

Regards,

Sajeevan