Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please attach the sample qlikview file.
Regards,
Jagan.
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
Hello,
Did anyone try the example?
Thanks.
Hi,
Can you qvw file without zipping it.
Regards,
Jagan.
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
The file with solution is attached.
Regards,
Sajeevan