topic Re: Line chart...each line representing a different year in QlikView https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321870#M1187903 <HTML><HEAD></HEAD><BODY><P> Thanks!&nbsp; That worked.</P></BODY></HTML> Fri, 07 Oct 2011 18:35:13 GMT 2011-10-07T18:35:13Z Line chart...each line representing a different year https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321866#M1187899 <HTML><HEAD></HEAD><BODY><P>I am trying to create a line chart of sales by month (x axis) with each year represented by a different line in the chart. Sales Year, Sales Month, and Gross Sales are all separate dimensions in the same table.&nbsp; The table represent 4 years worth of data.&nbsp; Not sure how to handle this through Expresssions.&nbsp; </P><P>Any help would be appreciated.</P></BODY></HTML> Fri, 07 Oct 2011 14:49:04 GMT https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321866#M1187899 2011-10-07T14:49:04Z Line chart...each line representing a different year https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321867#M1187900 <HTML><HEAD></HEAD><BODY><P>Can you post an example on how the data is currently displaying, and how you would like to see it displayed?</P></BODY></HTML> Fri, 07 Oct 2011 15:02:25 GMT https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321867#M1187900 2011-10-07T15:02:25Z Re: Line chart...each line representing a different year https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321868#M1187901 <HTML><HEAD></HEAD><BODY><P>I have attached a screen shot showing both the chart and the properties box with the expression.&nbsp; The chart is showing a line for Gross Written Premium for the sum of 2009, 2010, and 2011.&nbsp; I need to display each year as a separate line over the months.</P></BODY></HTML> Fri, 07 Oct 2011 15:16:00 GMT https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321868#M1187901 2011-10-07T15:16:00Z Re: Line chart...each line representing a different year https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321869#M1187902 <HTML><HEAD></HEAD><BODY><P>Just add another dimension for the Year,</P><P>So your dimensions would be Month, and Year.</P><P></P><P>Leave the expression as it is.</P></BODY></HTML> Fri, 07 Oct 2011 15:17:50 GMT https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321869#M1187902 2011-10-07T15:17:50Z Re: Line chart...each line representing a different year https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321870#M1187903 <HTML><HEAD></HEAD><BODY><P> Thanks!&nbsp; That worked.</P></BODY></HTML> Fri, 07 Oct 2011 18:35:13 GMT https://community.qlik.com/t5/QlikView/Line-chart-each-line-representing-a-different-year/m-p/321870#M1187903 2011-10-07T18:35:13Z