topic RangeSum Week Sales in App Development https://community.qlik.com/t5/App-Development/RangeSum-Week-Sales/m-p/113002#M7798 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Any way that Range Sum can be used to sum up the previous Calendar weeks sales?&nbsp; I have an expression, but it does not provide the desired data. </P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Expression I have:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RangeSum(Distinct{$&lt;Timestamp([completed_date])={"&gt;=num(today())-7&lt;=num(today())"}&gt;}(order_total), (order_id))</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Maybe using week, weekstart, or weekend functions, but not sure.&nbsp; Any help?&nbsp; Thanks in advance.</P></BODY></HTML> Wed, 26 Sep 2018 18:22:43 GMT Anonymous 2018-09-26T18:22:43Z RangeSum Week Sales https://community.qlik.com/t5/App-Development/RangeSum-Week-Sales/m-p/113002#M7798 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Any way that Range Sum can be used to sum up the previous Calendar weeks sales?&nbsp; I have an expression, but it does not provide the desired data. </P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Expression I have:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RangeSum(Distinct{$&lt;Timestamp([completed_date])={"&gt;=num(today())-7&lt;=num(today())"}&gt;}(order_total), (order_id))</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Maybe using week, weekstart, or weekend functions, but not sure.&nbsp; Any help?&nbsp; Thanks in advance.</P></BODY></HTML> Wed, 26 Sep 2018 18:22:43 GMT https://community.qlik.com/t5/App-Development/RangeSum-Week-Sales/m-p/113002#M7798 Anonymous 2018-09-26T18:22:43Z