topic Reference line in chart in QlikView https://community.qlik.com/t5/QlikView/Reference-line-in-chart/m-p/223347#M75881 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am looking to have a reference line in my chart which would give previous years Ontime %average based on year selection. i.e if 2009 selected than 2008 average is given.</P><P>Ontime % is calculated per distinct Document Numbers received based on receive date selection.</P><P>I am able to show average as per the same year selection by the expression</P><H4>=-sum(aggr([Transit Time] &gt;= ([Receipt Date] - [Ship Date]),[Doc. Number]))/count(distinct [Doc. Number]</H4><P></P><P>How Can i include previous year parametr within this expression.</P><P></P><P>Thansk for any help.</P><P>Kiran.</P><P>)</P></BODY></HTML> Wed, 27 Jan 2010 00:24:22 GMT 2010-01-27T00:24:22Z Reference line in chart https://community.qlik.com/t5/QlikView/Reference-line-in-chart/m-p/223347#M75881 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am looking to have a reference line in my chart which would give previous years Ontime %average based on year selection. i.e if 2009 selected than 2008 average is given.</P><P>Ontime % is calculated per distinct Document Numbers received based on receive date selection.</P><P>I am able to show average as per the same year selection by the expression</P><H4>=-sum(aggr([Transit Time] &gt;= ([Receipt Date] - [Ship Date]),[Doc. Number]))/count(distinct [Doc. Number]</H4><P></P><P>How Can i include previous year parametr within this expression.</P><P></P><P>Thansk for any help.</P><P>Kiran.</P><P>)</P></BODY></HTML> Wed, 27 Jan 2010 00:24:22 GMT https://community.qlik.com/t5/QlikView/Reference-line-in-chart/m-p/223347#M75881 2010-01-27T00:24:22Z