topic Re: Two variables in chart connected to different axis? in QlikView https://community.qlik.com/t5/QlikView/Two-variables-in-chart-connected-to-different-axis/m-p/379294#M141444 <HTML><HEAD></HEAD><BODY><P>You can use a secondary axis, similar to in Excel. Put both expressions in to your graph, then on the Axes tab of Chart Properties, select one of the expressions and select Right (Top) under 'Position'. If you upload an example, I can show you what I mean. </P></BODY></HTML> Mon, 20 Aug 2012 18:23:46 GMT 2012-08-20T18:23:46Z Two variables in chart connected to different axis? https://community.qlik.com/t5/QlikView/Two-variables-in-chart-connected-to-different-axis/m-p/379293#M141443 <HTML><HEAD></HEAD><BODY><P>Hey guys! This should be simple, I suppose.</P><P></P><P>I would like to represent 2 variables in the same chart (probably a bar and a line) - they are very connected but the quantities are very different. </P><P></P><P>One is the amount of tickets in a certain time, the other is the average expenditure per ticket. (E.g: each client spent ~$150 that week, and the total number of tickets was 2500). Since the numbers are very different, they don't look good in the same chart, connected to the same axis. How could I solve this?</P><P></P><P>Thanks! Cheers <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 20 Aug 2012 17:11:35 GMT https://community.qlik.com/t5/QlikView/Two-variables-in-chart-connected-to-different-axis/m-p/379293#M141443 2012-08-20T17:11:35Z Re: Two variables in chart connected to different axis? https://community.qlik.com/t5/QlikView/Two-variables-in-chart-connected-to-different-axis/m-p/379294#M141444 <HTML><HEAD></HEAD><BODY><P>You can use a secondary axis, similar to in Excel. Put both expressions in to your graph, then on the Axes tab of Chart Properties, select one of the expressions and select Right (Top) under 'Position'. If you upload an example, I can show you what I mean. </P></BODY></HTML> Mon, 20 Aug 2012 18:23:46 GMT https://community.qlik.com/t5/QlikView/Two-variables-in-chart-connected-to-different-axis/m-p/379294#M141444 2012-08-20T18:23:46Z Re: Two variables in chart connected to different axis? https://community.qlik.com/t5/QlikView/Two-variables-in-chart-connected-to-different-axis/m-p/379295#M141445 <HTML><HEAD></HEAD><BODY><P>Here is an example.</P></BODY></HTML> Mon, 20 Aug 2012 18:26:14 GMT https://community.qlik.com/t5/QlikView/Two-variables-in-chart-connected-to-different-axis/m-p/379295#M141445 2012-08-20T18:26:14Z Re: Two variables in chart connected to different axis? https://community.qlik.com/t5/QlikView/Two-variables-in-chart-connected-to-different-axis/m-p/379296#M141446 <HTML><HEAD></HEAD><BODY><P>Yes, it worked <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Mon, 20 Aug 2012 19:47:47 GMT https://community.qlik.com/t5/QlikView/Two-variables-in-chart-connected-to-different-axis/m-p/379296#M141446 2012-08-20T19:47:47Z