topic Re: Average Rate on Combo chart in QlikView https://community.qlik.com/t5/QlikView/Average-Rate-on-Combo-chart/m-p/139505#M20820 <HTML><HEAD></HEAD><BODY><P>Nope. A chart can only have two scales. And the second one is always one too many too imho.</P></BODY></HTML> Fri, 26 Oct 2018 08:02:25 GMT Gysbert_Wassenaar 2018-10-26T08:02:25Z Average Rate on Combo chart https://community.qlik.com/t5/QlikView/Average-Rate-on-Combo-chart/m-p/139502#M20817 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>I have a requirement like to represent&nbsp; average rate on combo chart using line.</P><P>In one left axis i am showing count and right axis amount using some dimension fields.</P><P>Now my average rate will</P><P>Amount/Count=Average rate,using line</P><P>Now problem is My charge in billion and count in million </P><P>so my average will be very less to show...</P><P>i want to show trend line for average....but what ever i am calculating it will always gives line in bottom only...because two axis having big value............</P><P>how can i represent this in best way ...</P><P>what would be the better to show..</P><P></P><P></P><P>Please help on same..</P><P>Thanks in advance,</P><P></P><P>Kavitha</P></BODY></HTML> Fri, 26 Oct 2018 04:52:03 GMT https://community.qlik.com/t5/QlikView/Average-Rate-on-Combo-chart/m-p/139502#M20817 kavitha_kommise 2018-10-26T04:52:03Z Re: Average Rate on Combo chart https://community.qlik.com/t5/QlikView/Average-Rate-on-Combo-chart/m-p/139503#M20818 <HTML><HEAD></HEAD><BODY><P>Use separate charts for each measure.</P></BODY></HTML> Fri, 26 Oct 2018 06:19:52 GMT https://community.qlik.com/t5/QlikView/Average-Rate-on-Combo-chart/m-p/139503#M20818 Gysbert_Wassenaar 2018-10-26T06:19:52Z Re: Average Rate on Combo chart https://community.qlik.com/t5/QlikView/Average-Rate-on-Combo-chart/m-p/139504#M20819 <HTML><HEAD></HEAD><BODY><P>can it possible to show in same chart?</P><P></P><P>Thanks and regards,</P><P>kavitha</P></BODY></HTML> Fri, 26 Oct 2018 06:31:01 GMT https://community.qlik.com/t5/QlikView/Average-Rate-on-Combo-chart/m-p/139504#M20819 kavitha_kommise 2018-10-26T06:31:01Z Re: Average Rate on Combo chart https://community.qlik.com/t5/QlikView/Average-Rate-on-Combo-chart/m-p/139505#M20820 <HTML><HEAD></HEAD><BODY><P>Nope. A chart can only have two scales. And the second one is always one too many too imho.</P></BODY></HTML> Fri, 26 Oct 2018 08:02:25 GMT https://community.qlik.com/t5/QlikView/Average-Rate-on-Combo-chart/m-p/139505#M20820 Gysbert_Wassenaar 2018-10-26T08:02:25Z