topic Re: Acumulative Sales in QlikView https://community.qlik.com/t5/QlikView/Acumulative-Sales/m-p/1249082#M849855 <HTML><HEAD></HEAD><BODY><P>I think you just need to remove your first total so make it</P><P></P><P><STRONG style="font-style: inherit; font-size: 13px; font-family: inherit; color: #3d3d3d;">=RangeSum(Above( Sum(Sales), 0, RowNo(TOTAL)))</STRONG></P></BODY></HTML> Tue, 21 Mar 2017 10:47:05 GMT adamdavi3s 2017-03-21T10:47:05Z Acumulative Sales https://community.qlik.com/t5/QlikView/Acumulative-Sales/m-p/1249081#M849854 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would like to make an expression than accumalates sales per month.</P><P></P><P>i have data from 2015 to ytd so i would like on the new year to start accumlating from 0</P><P></P><P>i mean imagine that on December 2015 i have 3000 sales, and on January 16 54 sales. </P><P></P><P>the data on jan 16 should be 54.</P><P></P><P>i have seen this formula, however it sums all the data and it doesn´t take into account the year.</P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><STRONG style="font-style: inherit; font-family: inherit;">=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))</STRONG></P><P><STRONG style="font-style: inherit; font-family: inherit;"><A _jive_internal="true" href="https://community.qlik.com/thread/181607#870833" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;" target="_blank">How to Calculate the Cumulative Month sales</A></STRONG></P><P></P><P></P><P>thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Acumulative-Sales/m-p/1249081#M849854 Anonymous 2020-11-25T16:16:04Z Re: Acumulative Sales https://community.qlik.com/t5/QlikView/Acumulative-Sales/m-p/1249082#M849855 <HTML><HEAD></HEAD><BODY><P>I think you just need to remove your first total so make it</P><P></P><P><STRONG style="font-style: inherit; font-size: 13px; font-family: inherit; color: #3d3d3d;">=RangeSum(Above( Sum(Sales), 0, RowNo(TOTAL)))</STRONG></P></BODY></HTML> Tue, 21 Mar 2017 10:47:05 GMT https://community.qlik.com/t5/QlikView/Acumulative-Sales/m-p/1249082#M849855 adamdavi3s 2017-03-21T10:47:05Z Re: Acumulative Sales https://community.qlik.com/t5/QlikView/Acumulative-Sales/m-p/1249083#M849856 <HTML><HEAD></HEAD><BODY><P>or this</P><P></P><P><STRONG style="font-style: inherit; font-size: 13px; font-family: inherit; color: #3d3d3d;">=RangeSum(Above(Sum(Sales), 0, RowNo()))</STRONG></P></BODY></HTML> Tue, 21 Mar 2017 10:58:23 GMT https://community.qlik.com/t5/QlikView/Acumulative-Sales/m-p/1249083#M849856 sunny_talwar 2017-03-21T10:58:23Z