topic Last 2 Years ascending in QlikView https://community.qlik.com/t5/QlikView/Last-2-Years-ascending/m-p/199246#M58253 <HTML><HEAD></HEAD><BODY><P>Hello guys</P><P>In a dashboard graph i need to show figures for the last two years (within the selection) ascending, meaning for today() the graph will show 2008 and 2009 (in that order).</P><P>With a sort by ascending on the Year I can achieve this on a 2 year selection, but of course not with no selection at all (as it will show the last 2 years).</P><P>Is there any way so solve this?</P><P>Im running 8.5</P></BODY></HTML> Fri, 25 Sep 2009 15:46:17 GMT blaise 2009-09-25T15:46:17Z Last 2 Years ascending https://community.qlik.com/t5/QlikView/Last-2-Years-ascending/m-p/199246#M58253 <HTML><HEAD></HEAD><BODY><P>Hello guys</P><P>In a dashboard graph i need to show figures for the last two years (within the selection) ascending, meaning for today() the graph will show 2008 and 2009 (in that order).</P><P>With a sort by ascending on the Year I can achieve this on a 2 year selection, but of course not with no selection at all (as it will show the last 2 years).</P><P>Is there any way so solve this?</P><P>Im running 8.5</P></BODY></HTML> Fri, 25 Sep 2009 15:46:17 GMT https://community.qlik.com/t5/QlikView/Last-2-Years-ascending/m-p/199246#M58253 blaise 2009-09-25T15:46:17Z Last 2 Years ascending https://community.qlik.com/t5/QlikView/Last-2-Years-ascending/m-p/199247#M58254 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see the attached example for help.</P><P>Play with the "Set Analysis" expression and see the results.</P><P>Another example are this one (three month period):</P><P></P><P>Sum ( {&lt; OrderDate={"&gt;=$(=addmonths(monthstart(max(OrderDate)),-2)) &lt;=$(=addmonths(monthend(max(OrderDate)),0))"}&gt;} Amount)</P><BR /><BR /> <P></P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Fri, 25 Sep 2009 18:56:29 GMT https://community.qlik.com/t5/QlikView/Last-2-Years-ascending/m-p/199247#M58254 2009-09-25T18:56:29Z