https://community.qlik.com/t5/App-Development/Calculate-difference-since-set-year/m-p/1570096#M41576 <P>Try this</P><PRE>Sum("Passenger Count") - Sum(<FONT color="#FF0000">TOTAL</FONT> {&lt;[Year]={'2012'} &gt;}"Passenger Count")</PRE> Tue, 16 Apr 2019 16:49:19 GMT sunny_talwar 2019-04-16T16:49:19Z https://community.qlik.com/t5/App-Development/Calculate-difference-since-set-year/m-p/1570084#M41574 <P>&nbsp;</P><P>&nbsp;</P><P>Hi guys, I need to calculate the increase/decrease every year compared to 2012.</P><P>The field expression I am using is: &nbsp;<STRONG>Sum("Passenger Count")&nbsp; - Sum({&lt;[Year]={'2012'} &gt;}"Passenger Count")</STRONG></P><P>The result only correctly calculates 2012:&nbsp; 69-69=0. The other years show actual Passenger count, not the increase/decrease. Where am I going wrong with this?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 357px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/10330i5B6BD10E8BEB7302/image-size/large?v=v2&amp;px=999" role="button" title="Untitled.png" alt="Untitled.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 16 Apr 2019 16:30:22 GMT https://community.qlik.com/t5/App-Development/Calculate-difference-since-set-year/m-p/1570084#M41574 martyn_birzys 2019-04-16T16:30:22Z https://community.qlik.com/t5/App-Development/Calculate-difference-since-set-year/m-p/1570096#M41576 <P>Try this</P><PRE>Sum("Passenger Count") - Sum(<FONT color="#FF0000">TOTAL</FONT> {&lt;[Year]={'2012'} &gt;}"Passenger Count")</PRE> Tue, 16 Apr 2019 16:49:19 GMT https://community.qlik.com/t5/App-Development/Calculate-difference-since-set-year/m-p/1570096#M41576 sunny_talwar 2019-04-16T16:49:19Z