Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Maximum of Bar Charts

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

Tags (1)
6 Replies
MVP
MVP

Maximum of Bar Charts

Hi,

Please attach the sample qlikview file.

Regards,

Jagan.

Not applicable

Re: Maximum of Bar Charts

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

Not applicable

Re: Maximum of Bar Charts

Hello,

Did anyone try the example?

Thanks.

MVP
MVP

Maximum of Bar Charts

Hi,

Can you qvw file without zipping it.

Regards,

Jagan.

Not applicable

Maximum of Bar Charts

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

Not applicable

Re: Maximum of Bar Charts

The file with solution is attached.

Regards,

Sajeevan

Community Browser