topic Line Chart displaying two seperate time periods in QlikView https://community.qlik.com/t5/QlikView/Line-Chart-displaying-two-seperate-time-periods/m-p/247445#M1208212 <HTML><HEAD></HEAD><BODY><P>I am trying to create a line chart that displays sales data from a year that I select and would like it to also show me the same data from the previous year, and have it all broken down by months. Would love it if someone could help me on this, thanks in advance.</P></BODY></HTML> Mon, 15 Mar 2010 16:30:37 GMT 2010-03-15T16:30:37Z Line Chart displaying two seperate time periods https://community.qlik.com/t5/QlikView/Line-Chart-displaying-two-seperate-time-periods/m-p/247445#M1208212 <HTML><HEAD></HEAD><BODY><P>I am trying to create a line chart that displays sales data from a year that I select and would like it to also show me the same data from the previous year, and have it all broken down by months. Would love it if someone could help me on this, thanks in advance.</P></BODY></HTML> Mon, 15 Mar 2010 16:30:37 GMT https://community.qlik.com/t5/QlikView/Line-Chart-displaying-two-seperate-time-periods/m-p/247445#M1208212 2010-03-15T16:30:37Z Line Chart displaying two seperate time periods https://community.qlik.com/t5/QlikView/Line-Chart-displaying-two-seperate-time-periods/m-p/247446#M1208214 <HTML><HEAD></HEAD><BODY><P>You will need two expressions ... (samples)</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />sum( {$&lt;Year = {$(=Only(Year))}&gt;} Sales )<BR />sum( {$&lt;Year = {$(=Only(Year)-1)}&gt;} Sales )<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>The first calculates the Sales for the selected Year and the second the same for the year before that.</P><P>You use the Month as a dimension.<BR /></P></BODY></HTML> Tue, 16 Mar 2010 10:25:09 GMT https://community.qlik.com/t5/QlikView/Line-Chart-displaying-two-seperate-time-periods/m-p/247446#M1208214 2010-03-16T10:25:09Z