topic Set Analysis and RangeSum in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-and-RangeSum/m-p/290416#M107797 <HTML><HEAD></HEAD><BODY><P>I am using the expression below to show cummulative sales on a chart the has monthly sales also.</P><P>rangesum(top(Sales , 1, RowNo() -0)) </P><P>The problem I am having is I need to add a set analysis expression:</P><P>{$&lt;RSM =-{10}&gt;} </P><P></P><P>I can get it to work.</P><P>Help</P><P>Thanks,</P><P>Stephen</P></BODY></HTML> Mon, 22 Aug 2011 17:45:42 GMT 2011-08-22T17:45:42Z Set Analysis and RangeSum https://community.qlik.com/t5/QlikView/Set-Analysis-and-RangeSum/m-p/290416#M107797 <HTML><HEAD></HEAD><BODY><P>I am using the expression below to show cummulative sales on a chart the has monthly sales also.</P><P>rangesum(top(Sales , 1, RowNo() -0)) </P><P>The problem I am having is I need to add a set analysis expression:</P><P>{$&lt;RSM =-{10}&gt;} </P><P></P><P>I can get it to work.</P><P>Help</P><P>Thanks,</P><P>Stephen</P></BODY></HTML> Mon, 22 Aug 2011 17:45:42 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-RangeSum/m-p/290416#M107797 2011-08-22T17:45:42Z Set Analysis and RangeSum https://community.qlik.com/t5/QlikView/Set-Analysis-and-RangeSum/m-p/290417#M107798 <HTML><HEAD></HEAD><BODY><P> Got it working.</P><P>rangesum(top(sum({$&lt;RSM =-{10}&gt;} Sales), 1, RowNo() -0)) </P></BODY></HTML> Mon, 22 Aug 2011 18:52:44 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-RangeSum/m-p/290417#M107798 2011-08-22T18:52:44Z