topic Re: Sum of previous data value based on Properties in QlikView https://community.qlik.com/t5/QlikView/Sum-of-previous-data-value-based-on-Properties/m-p/839619#M295101 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Expression&nbsp; : aggr(RangeSum(Above(Sum(Value),0,NoOfRows())),Category,Date)</SPAN></P></BODY></HTML> Thu, 17 Dec 2015 08:03:16 GMT silambarasan 2015-12-17T08:03:16Z Sum of previous data value based on Properties https://community.qlik.com/t5/QlikView/Sum-of-previous-data-value-based-on-Properties/m-p/839616#M295098 <HTML><HEAD></HEAD><BODY><P>I have table data like the below,</P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Properties&nbsp; Value</P><P>01-01-2012&nbsp;&nbsp; Fridge&nbsp;&nbsp; 20</P><P>05-05-2012&nbsp;&nbsp; Fridge&nbsp;&nbsp; 30</P><P>01-01-2012&nbsp;&nbsp;&nbsp;&nbsp; A/C&nbsp;&nbsp;&nbsp; 30</P><P>02-02-2012&nbsp;&nbsp;&nbsp;&nbsp; A/C&nbsp;&nbsp;&nbsp; 40</P><P>02-02-2012&nbsp;&nbsp;&nbsp;&nbsp; TV&nbsp;&nbsp;&nbsp;&nbsp; 60</P><P>07-07-2012&nbsp;&nbsp;&nbsp; Fridge 70</P><P>08-09-2012&nbsp;&nbsp;&nbsp; LCD&nbsp;&nbsp; 40</P><P>30-09-2012&nbsp;&nbsp;&nbsp; LCD&nbsp;&nbsp; 40</P><P></P><P>I want the result in the below</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Properties&nbsp;&nbsp; Value</P><P>01-01-2012&nbsp;&nbsp; Fridge&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>05-05-2012&nbsp;&nbsp; Fridge&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>01-01-2012&nbsp;&nbsp;&nbsp; A/C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>02-02-2012&nbsp;&nbsp;&nbsp; A/C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70</P><P>02-02-2012&nbsp;&nbsp;&nbsp; TV&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</P><P>07-07-2012&nbsp;&nbsp; Fridge&nbsp;&nbsp; 120</P><P>08-09-2012&nbsp;&nbsp;&nbsp; LCD&nbsp;&nbsp;&nbsp;&nbsp; 40</P><P>30-09-2012&nbsp;&nbsp;&nbsp; LCD&nbsp;&nbsp;&nbsp; 80</P><P>How to get this result </P></BODY></HTML> Wed, 15 Apr 2015 13:54:17 GMT https://community.qlik.com/t5/QlikView/Sum-of-previous-data-value-based-on-Properties/m-p/839616#M295098 2015-04-15T13:54:17Z Re: Sum of previous data value based on Properties https://community.qlik.com/t5/QlikView/Sum-of-previous-data-value-based-on-Properties/m-p/839617#M295099 <HTML><HEAD></HEAD><BODY><P>Anyone having idea...above my question</P></BODY></HTML> Thu, 16 Apr 2015 09:10:19 GMT https://community.qlik.com/t5/QlikView/Sum-of-previous-data-value-based-on-Properties/m-p/839617#M295099 2015-04-16T09:10:19Z Re: Sum of previous data value based on Properties https://community.qlik.com/t5/QlikView/Sum-of-previous-data-value-based-on-Properties/m-p/839618#M295100 <HTML><HEAD></HEAD><BODY><P>Dimension&nbsp;&nbsp; :&nbsp;&nbsp; Date</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Properties</P><P></P><P>Expression&nbsp;&nbsp; :&nbsp; sum( aggr( rangesum( above( sum(Value),0,NoOfRows()) ),Properties,Date))</P></BODY></HTML> Thu, 17 Dec 2015 07:46:45 GMT https://community.qlik.com/t5/QlikView/Sum-of-previous-data-value-based-on-Properties/m-p/839618#M295100 silambarasan 2015-12-17T07:46:45Z Re: Sum of previous data value based on Properties https://community.qlik.com/t5/QlikView/Sum-of-previous-data-value-based-on-Properties/m-p/839619#M295101 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Expression&nbsp; : aggr(RangeSum(Above(Sum(Value),0,NoOfRows())),Category,Date)</SPAN></P></BODY></HTML> Thu, 17 Dec 2015 08:03:16 GMT https://community.qlik.com/t5/QlikView/Sum-of-previous-data-value-based-on-Properties/m-p/839619#M295101 silambarasan 2015-12-17T08:03:16Z