https://community.qlik.com/t5/QlikView/Expression-to-include-previous-year-Sales/m-p/1041003#M350349 <HTML><HEAD></HEAD><BODY><P>Or even better, try this:</P><P></P><P><STRONG>Sum(A)/(Above(Sum({&lt;Year&gt;}B)) * Avg(1))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121800_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Fri, 15 Apr 2016 17:15:41 GMT sunny_talwar 2016-04-15T17:15:41Z https://community.qlik.com/t5/QlikView/Expression-to-include-previous-year-Sales/m-p/1041001#M350347 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>The required calculation is</P><P>Flow% = Sum(A) for the current Year / sum(B) of the previous year.</P><P></P><P>Can you please help me in acheving this keeping Year as Dimension. How can i acheive this in a Pivot table.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121776_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Flow% = Sum(A) of Tn / sum(B) of T(n-1)</P></BODY></HTML> Fri, 15 Apr 2016 11:33:05 GMT https://community.qlik.com/t5/QlikView/Expression-to-include-previous-year-Sales/m-p/1041001#M350347 2016-04-15T11:33:05Z https://community.qlik.com/t5/QlikView/Expression-to-include-previous-year-Sales/m-p/1041002#M350348 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Sum(A)/Above(Sum(B))</STRONG></P></BODY></HTML> Fri, 15 Apr 2016 17:12:07 GMT https://community.qlik.com/t5/QlikView/Expression-to-include-previous-year-Sales/m-p/1041002#M350348 sunny_talwar 2016-04-15T17:12:07Z https://community.qlik.com/t5/QlikView/Expression-to-include-previous-year-Sales/m-p/1041003#M350349 <HTML><HEAD></HEAD><BODY><P>Or even better, try this:</P><P></P><P><STRONG>Sum(A)/(Above(Sum({&lt;Year&gt;}B)) * Avg(1))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/121800_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Fri, 15 Apr 2016 17:15:41 GMT https://community.qlik.com/t5/QlikView/Expression-to-include-previous-year-Sales/m-p/1041003#M350349 sunny_talwar 2016-04-15T17:15:41Z