topic Configure 2 y-axis to be dynamically proportional to each other in QlikView https://community.qlik.com/t5/QlikView/Configure-2-y-axis-to-be-dynamically-proportional-to-each-other/m-p/275527#M102810 <HTML><HEAD></HEAD><BODY><P>I have a line graph with 2 y-axis. I need the right axis to be proportional to the left axis 1:7. But I cannot use Static Max settings, as the max values change when filtering.</P></BODY></HTML> Tue, 25 Oct 2011 23:02:59 GMT Anonymous 2011-10-25T23:02:59Z Configure 2 y-axis to be dynamically proportional to each other https://community.qlik.com/t5/QlikView/Configure-2-y-axis-to-be-dynamically-proportional-to-each-other/m-p/275527#M102810 <HTML><HEAD></HEAD><BODY><P>I have a line graph with 2 y-axis. I need the right axis to be proportional to the left axis 1:7. But I cannot use Static Max settings, as the max values change when filtering.</P></BODY></HTML> Tue, 25 Oct 2011 23:02:59 GMT https://community.qlik.com/t5/QlikView/Configure-2-y-axis-to-be-dynamically-proportional-to-each-other/m-p/275527#M102810 Anonymous 2011-10-25T23:02:59Z Configure 2 y-axis to be dynamically proportional to each other https://community.qlik.com/t5/QlikView/Configure-2-y-axis-to-be-dynamically-proportional-to-each-other/m-p/275528#M102811 <HTML><HEAD></HEAD><BODY><P>Use max(aggr()) function on the first expression for each of the dimensions. Make a variable out of this and use it as max value for the expression. For the second expression use 7*variable as max value.</P><P></P><P>Hope this helps,</P><P>Kiran.</P></BODY></HTML> Wed, 26 Oct 2011 09:07:30 GMT https://community.qlik.com/t5/QlikView/Configure-2-y-axis-to-be-dynamically-proportional-to-each-other/m-p/275528#M102811 2011-10-26T09:07:30Z Configure 2 y-axis to be dynamically proportional to each other https://community.qlik.com/t5/QlikView/Configure-2-y-axis-to-be-dynamically-proportional-to-each-other/m-p/275529#M102812 <HTML><HEAD></HEAD><BODY><P> Kiran,</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 26 Oct 2011 21:36:01 GMT https://community.qlik.com/t5/QlikView/Configure-2-y-axis-to-be-dynamically-proportional-to-each-other/m-p/275529#M102812 Anonymous 2011-10-26T21:36:01Z