topic Re: current & previous year in QlikView https://community.qlik.com/t5/QlikView/current-previous-year/m-p/419050#M155899 <HTML><HEAD></HEAD><BODY><P> it works ! thank u</P></BODY></HTML> Wed, 03 Apr 2013 15:39:57 GMT 2013-04-03T15:39:57Z current & previous year https://community.qlik.com/t5/QlikView/current-previous-year/m-p/419048#M155897 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I need to compare the sum(sales) of the current year with the previous one,</P><P>How can I do it ?</P></BODY></HTML> Wed, 03 Apr 2013 14:29:18 GMT https://community.qlik.com/t5/QlikView/current-previous-year/m-p/419048#M155897 2013-04-03T14:29:18Z Re: current & previous year https://community.qlik.com/t5/QlikView/current-previous-year/m-p/419049#M155898 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P>Current year: sum({&lt;Year = {'$(=year(today()))'&gt;}sales) </P><P>Previous year: sum({&lt;Year = {'$(=year(today())-1)'}&gt;}sales) </P><P></P><P>Replace Year and sales with your field names.</P></BODY></HTML> Wed, 03 Apr 2013 14:39:02 GMT https://community.qlik.com/t5/QlikView/current-previous-year/m-p/419049#M155898 Gysbert_Wassenaar 2013-04-03T14:39:02Z Re: current & previous year https://community.qlik.com/t5/QlikView/current-previous-year/m-p/419050#M155899 <HTML><HEAD></HEAD><BODY><P> it works ! thank u</P></BODY></HTML> Wed, 03 Apr 2013 15:39:57 GMT https://community.qlik.com/t5/QlikView/current-previous-year/m-p/419050#M155899 2013-04-03T15:39:57Z