topic Re: How to sum last year. in QlikView https://community.qlik.com/t5/QlikView/How-to-sum-last-year/m-p/683079#M677824 <HTML><HEAD></HEAD><BODY><P>sum({&lt;Year={$(=Max(Year)-1)}&gt;} &lt;your field&gt;)</P></BODY></HTML> Mon, 16 Jun 2014 03:59:40 GMT 2014-06-16T03:59:40Z How to sum last year. https://community.qlik.com/t5/QlikView/How-to-sum-last-year/m-p/683078#M677823 <HTML><HEAD></HEAD><BODY><P>I select&nbsp; current year(don't care Month) from list box for sum product but i don't know scrip to sum product last year.</P><P>Ex</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Item</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sum all 2014</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sum all 2013</TH></TR><TR><TD style="padding: 2px;">101</TD><TD style="padding: 2px; text-align: center;">3000</TD><TD style="padding: 2px; text-align: center;">?</TD></TR><TR><TD style="padding: 2px;">102</TD><TD style="padding: 2px; text-align: center;">4000</TD><TD style="padding: 2px; text-align: center;">?</TD></TR></TBODY></TABLE><P></P><P>anyone have a idea?</P></BODY></HTML> Mon, 16 Jun 2014 03:54:45 GMT https://community.qlik.com/t5/QlikView/How-to-sum-last-year/m-p/683078#M677823 2014-06-16T03:54:45Z Re: How to sum last year. https://community.qlik.com/t5/QlikView/How-to-sum-last-year/m-p/683079#M677824 <HTML><HEAD></HEAD><BODY><P>sum({&lt;Year={$(=Max(Year)-1)}&gt;} &lt;your field&gt;)</P></BODY></HTML> Mon, 16 Jun 2014 03:59:40 GMT https://community.qlik.com/t5/QlikView/How-to-sum-last-year/m-p/683079#M677824 2014-06-16T03:59:40Z Re: How to sum last year. https://community.qlik.com/t5/QlikView/How-to-sum-last-year/m-p/683080#M677825 <HTML><HEAD></HEAD><BODY><P>please help.If i want to sum all last year.what code look like.</P></BODY></HTML> Thu, 05 Mar 2015 15:03:56 GMT https://community.qlik.com/t5/QlikView/How-to-sum-last-year/m-p/683080#M677825 2015-03-05T15:03:56Z