topic How can I create a line chart with 2 dimensions and one expression in QlikView https://community.qlik.com/t5/QlikView/How-can-I-create-a-line-chart-with-2-dimensions-and-one/m-p/320334#M118060 <HTML><HEAD></HEAD><BODY><P> Thanks - that did help, I recoded my variable using the Rangesum function to get rid of the need for the 2nd variable.</P><P></P><P>I have another query now!</P><P>The Active rate calculates correctly when I show it as a pivot table, however when I turn it into a chart, the points show as a percentage of the previous data point, rather than the data when it is in a pivot table!</P><P></P><P>Any thoughts to why that might be?</P><P>(Seems to be something to do with having two dimensions as charts fine when I remove the 2nd dimension</P></BODY></HTML> Tue, 28 Jun 2011 10:10:43 GMT 2011-06-28T10:10:43Z How can I create a line chart with 2 dimensions and one expression https://community.qlik.com/t5/QlikView/How-can-I-create-a-line-chart-with-2-dimensions-and-one/m-p/320332#M118058 <HTML><HEAD></HEAD><BODY><P>I want to create a line chart with 2 dimensions and one expression.&nbsp; The problem I have is that there are two expressions in my object.</P><P>1) Active Rate 2) Cumulative Inactives.</P><P>I want to chart Active Rate by the two dimensions, however I cant remove Cumulative Inactives from the chart object as active rate uses this to calculate itself.</P><P>Just hiding Cumulative inactives does nt work.</P><P></P><P>Any help would be appreciated.</P></BODY></HTML> Fri, 24 Jun 2011 16:52:38 GMT https://community.qlik.com/t5/QlikView/How-can-I-create-a-line-chart-with-2-dimensions-and-one/m-p/320332#M118058 2011-06-24T16:52:38Z How can I create a line chart with 2 dimensions and one expression https://community.qlik.com/t5/QlikView/How-can-I-create-a-line-chart-with-2-dimensions-and-one/m-p/320333#M118059 <HTML><HEAD></HEAD><BODY><P>Hi Lee,</P><P></P><P>Can you not just include the expression for Cum. Inactives in the expression for Active Rate?</P><P></P><P></P><P>Regards,</P><P></P><P></P><P><BR />Stephen</P></BODY></HTML> Fri, 24 Jun 2011 16:56:59 GMT https://community.qlik.com/t5/QlikView/How-can-I-create-a-line-chart-with-2-dimensions-and-one/m-p/320333#M118059 stephencredmond 2011-06-24T16:56:59Z How can I create a line chart with 2 dimensions and one expression https://community.qlik.com/t5/QlikView/How-can-I-create-a-line-chart-with-2-dimensions-and-one/m-p/320334#M118060 <HTML><HEAD></HEAD><BODY><P> Thanks - that did help, I recoded my variable using the Rangesum function to get rid of the need for the 2nd variable.</P><P></P><P>I have another query now!</P><P>The Active rate calculates correctly when I show it as a pivot table, however when I turn it into a chart, the points show as a percentage of the previous data point, rather than the data when it is in a pivot table!</P><P></P><P>Any thoughts to why that might be?</P><P>(Seems to be something to do with having two dimensions as charts fine when I remove the 2nd dimension</P></BODY></HTML> Tue, 28 Jun 2011 10:10:43 GMT https://community.qlik.com/t5/QlikView/How-can-I-create-a-line-chart-with-2-dimensions-and-one/m-p/320334#M118060 2011-06-28T10:10:43Z