topic RangeSum Script for Dimension in QlikView https://community.qlik.com/t5/QlikView/RangeSum-Script-for-Dimension/m-p/140817#M600745 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need RangeSum for Category. How to build this function in my script for this table?</P><P>Final table should be</P><P>A,1,10;</P><P>A,3, 25;</P><P>D,2,5;</P><P>D,3,10</P><P></P><P>Test:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Category, K, Value&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp; A, 1, 10</P><P>&nbsp;&nbsp;&nbsp; A, 3, 15</P><P>&nbsp;&nbsp;&nbsp; D, 2, 5</P><P>&nbsp;&nbsp;&nbsp; D, 3, 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>];</P><P></P><P>Tmp_Test:</P><P>NoConcatenate</P><P>Load </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Category,</P><P>&nbsp;&nbsp;&nbsp; K,</P><P>&nbsp;&nbsp;&nbsp; RangeSum(Value) as Cum</P><P>Resident Test;</P></BODY></HTML> Sun, 28 Oct 2018 13:07:04 GMT Anonymous 2018-10-28T13:07:04Z RangeSum Script for Dimension https://community.qlik.com/t5/QlikView/RangeSum-Script-for-Dimension/m-p/140817#M600745 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need RangeSum for Category. How to build this function in my script for this table?</P><P>Final table should be</P><P>A,1,10;</P><P>A,3, 25;</P><P>D,2,5;</P><P>D,3,10</P><P></P><P>Test:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Category, K, Value&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp; A, 1, 10</P><P>&nbsp;&nbsp;&nbsp; A, 3, 15</P><P>&nbsp;&nbsp;&nbsp; D, 2, 5</P><P>&nbsp;&nbsp;&nbsp; D, 3, 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>];</P><P></P><P>Tmp_Test:</P><P>NoConcatenate</P><P>Load </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Category,</P><P>&nbsp;&nbsp;&nbsp; K,</P><P>&nbsp;&nbsp;&nbsp; RangeSum(Value) as Cum</P><P>Resident Test;</P></BODY></HTML> Sun, 28 Oct 2018 13:07:04 GMT https://community.qlik.com/t5/QlikView/RangeSum-Script-for-Dimension/m-p/140817#M600745 Anonymous 2018-10-28T13:07:04Z Re: RangeSum Script for Dimension https://community.qlik.com/t5/QlikView/RangeSum-Script-for-Dimension/m-p/140818#M600746 <HTML><HEAD></HEAD><BODY><P>Please don't post the same question multiple times, it makes it hard to follow a discussion and is a waste of ressources.</P><P><A href="https://community.qlik.com/thread/318185">RangeSum Script for Dimension</A></P></BODY></HTML> Sun, 28 Oct 2018 14:09:04 GMT https://community.qlik.com/t5/QlikView/RangeSum-Script-for-Dimension/m-p/140818#M600746 swuehl 2018-10-28T14:09:04Z