topic Previous year figures in QlikView https://community.qlik.com/t5/QlikView/Previous-year-figures/m-p/311399#M114943 <HTML><HEAD></HEAD><BODY><P>I have a problem with my expression to populate purchases amount for the previous year, sum({$&lt;Year={$(=Only(Year)-1)}&gt;}LineTotal)&nbsp; . The one to get current year figures sum({$&lt;Year={$(=Only(Year))}&gt;}LineTotal) is working perfectly fine.Can someone assist me in fixing this.</P></BODY></HTML> Thu, 23 Feb 2012 08:07:31 GMT 2012-02-23T08:07:31Z Previous year figures https://community.qlik.com/t5/QlikView/Previous-year-figures/m-p/311399#M114943 <HTML><HEAD></HEAD><BODY><P>I have a problem with my expression to populate purchases amount for the previous year, sum({$&lt;Year={$(=Only(Year)-1)}&gt;}LineTotal)&nbsp; . The one to get current year figures sum({$&lt;Year={$(=Only(Year))}&gt;}LineTotal) is working perfectly fine.Can someone assist me in fixing this.</P></BODY></HTML> Thu, 23 Feb 2012 08:07:31 GMT https://community.qlik.com/t5/QlikView/Previous-year-figures/m-p/311399#M114943 2012-02-23T08:07:31Z Previous year figures https://community.qlik.com/t5/QlikView/Previous-year-figures/m-p/311400#M114944 <HTML><HEAD></HEAD><BODY><P> I have checked your expression and it is working fine for me. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 23 Feb 2012 08:14:29 GMT https://community.qlik.com/t5/QlikView/Previous-year-figures/m-p/311400#M114944 vijay_iitkgp 2012-02-23T08:14:29Z Previous year figures https://community.qlik.com/t5/QlikView/Previous-year-figures/m-p/311401#M114945 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try with this expression</P><P></P><P>sum({$&lt;Year={'=$(=(Max(Year)-1))'}&gt;}LineTotal)</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Thu, 23 Feb 2012 08:28:21 GMT https://community.qlik.com/t5/QlikView/Previous-year-figures/m-p/311401#M114945 jagan 2012-02-23T08:28:21Z Re: Previous year figures https://community.qlik.com/t5/QlikView/Previous-year-figures/m-p/311402#M114946 <HTML><HEAD></HEAD><BODY><P>Thanks, let me try it</P></BODY></HTML> Thu, 23 Feb 2012 12:26:36 GMT https://community.qlik.com/t5/QlikView/Previous-year-figures/m-p/311402#M114946 2012-02-23T12:26:36Z