topic What is the expression meaning? in QlikView https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171909#M896076 <HTML><HEAD></HEAD><BODY><P>What is the expression meaning?Please give an example.</P><P></P><P>RangeSum(before(COUNT(PolicyCounter),0,ColumnNo()))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT arethaking 2020-11-25T16:16:04Z What is the expression meaning? https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171909#M896076 <HTML><HEAD></HEAD><BODY><P>What is the expression meaning?Please give an example.</P><P></P><P>RangeSum(before(COUNT(PolicyCounter),0,ColumnNo()))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171909#M896076 arethaking 2020-11-25T16:16:04Z Re: What is the expression meaning? https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171910#M896077 <HTML><HEAD></HEAD><BODY><P>This expression will sum every value into <SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">COUNT(PolicyCounter) from first column until current one</SPAN></P></BODY></HTML> Thu, 28 Jul 2016 16:06:11 GMT https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171910#M896077 Clever_Anjos 2016-07-28T16:06:11Z Re: What is the expression meaning? https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171911#M896078 <HTML><HEAD></HEAD><BODY><P>hi Aretha,</P><P></P><P>it calculates the cumulative sum of counts in pivot table.</P><P>in chart or a straight table you would use "above" instead of "before".</P><P></P><P>hope that helps</P></BODY></HTML> Thu, 28 Jul 2016 16:12:42 GMT https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171911#M896078 Frank_Hartmann 2016-07-28T16:12:42Z Re: What is the expression meaning? https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171912#M896079 <HTML><HEAD></HEAD><BODY><P>Please explain with this example</P><P></P><P>Load * INLINE [S.No,PolicyCounter</P><P>1,2</P><P>2,12</P><P>3,34</P><P>4,89</P><P>5,80</P><P>]</P></BODY></HTML> Thu, 28 Jul 2016 16:18:54 GMT https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171912#M896079 arethaking 2016-07-28T16:18:54Z Re: What is the expression meaning? https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171913#M896080 <HTML><HEAD></HEAD><BODY><P>It seems like an expression used in a pivot table where you are accumulating based on your pivoted dimension. So assuming S.No as your dimension, you will get something like this.</P><P></P><P><STRONG>S.No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp; 5</STRONG></P><P><STRONG>ExpResult&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp; 48&nbsp;&nbsp; 137&nbsp; 217&nbsp; </STRONG></P></BODY></HTML> Thu, 28 Jul 2016 16:41:22 GMT https://community.qlik.com/t5/QlikView/What-is-the-expression-meaning/m-p/1171913#M896080 sunny_talwar 2016-07-28T16:41:22Z