topic Re: Sum a backward in QlikView https://community.qlik.com/t5/QlikView/Sum-a-backward/m-p/1446979#M797101 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Sum({&lt;DateField = {'$(=AddYears(Max(DateField),-1))'}&gt;} Sales)</STRONG></P></BODY></HTML> Thu, 07 Dec 2017 17:41:39 GMT Anil_Babu_Samineni 2017-12-07T17:41:39Z Sum a backward https://community.qlik.com/t5/QlikView/Sum-a-backward/m-p/1446978#M797100 <HTML><HEAD></HEAD><BODY><P>Problen with sum</P><P></P><P>In the first column I would like to have sum with sum date 2017-05-01and in the other column sum date 2016-05-01</P><P></P><P>ex</P><P>how big was sales, last year at a specific date</P><P></P><P>//Janne</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sum-a-backward/m-p/1446978#M797100 Anonymous 2020-11-25T16:16:04Z Re: Sum a backward https://community.qlik.com/t5/QlikView/Sum-a-backward/m-p/1446979#M797101 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Sum({&lt;DateField = {'$(=AddYears(Max(DateField),-1))'}&gt;} Sales)</STRONG></P></BODY></HTML> Thu, 07 Dec 2017 17:41:39 GMT https://community.qlik.com/t5/QlikView/Sum-a-backward/m-p/1446979#M797101 Anil_Babu_Samineni 2017-12-07T17:41:39Z Re: Sum a backward https://community.qlik.com/t5/QlikView/Sum-a-backward/m-p/1446980#M797102 <HTML><HEAD></HEAD><BODY><P>What is your chart dimension here?</P></BODY></HTML> Thu, 07 Dec 2017 17:46:37 GMT https://community.qlik.com/t5/QlikView/Sum-a-backward/m-p/1446980#M797102 sunny_talwar 2017-12-07T17:46:37Z Re: Sum a backward https://community.qlik.com/t5/QlikView/Sum-a-backward/m-p/1446981#M797103 <HTML><HEAD></HEAD><BODY><P>I have tried that variant but it will only be 0</P><P></P><P></P><P>//=Sum({&lt;Date = {'$(=AddYears(Max(Date),-1))'}&gt;} sales) </P><P></P><P>21767454,82-&gt;2016-05-01</P><P>3201530,09 -&gt;2017-05-01</P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Fri, 08 Dec 2017 13:28:34 GMT https://community.qlik.com/t5/QlikView/Sum-a-backward/m-p/1446981#M797103 Anonymous 2017-12-08T13:28:34Z