topic Re: How to do a YTD calculation in QlikView https://community.qlik.com/t5/QlikView/How-to-do-a-YTD-calculation/m-p/1335101#M825110 <HTML><HEAD></HEAD><BODY><P>Before and ColumnNo() are used in Pivot table... try with Above and RowNo() instead</P><P></P><P><STRONG>RangeSum(<SPAN style="color: #ff0000;">Above</SPAN>(Sum({&lt;GL_1 = {VOL}, Dimension = {RFC}&gt;} Data), 0, <SPAN style="color: #ff0000;">RowNo</SPAN>()))</STRONG></P></BODY></HTML> Wed, 19 Jul 2017 12:35:14 GMT sunny_talwar 2017-07-19T12:35:14Z How to do a YTD calculation https://community.qlik.com/t5/QlikView/How-to-do-a-YTD-calculation/m-p/1335100#M825109 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>After reading some of the posts on YTD calculations, I came to the below formula, however it seems I've done something wrong.</P><P></P><P></P><P>Any idea where I made a mistake in this formula?</P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/170732_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-a-YTD-calculation/m-p/1335100#M825109 tim_leijen 2020-11-25T16:16:04Z Re: How to do a YTD calculation https://community.qlik.com/t5/QlikView/How-to-do-a-YTD-calculation/m-p/1335101#M825110 <HTML><HEAD></HEAD><BODY><P>Before and ColumnNo() are used in Pivot table... try with Above and RowNo() instead</P><P></P><P><STRONG>RangeSum(<SPAN style="color: #ff0000;">Above</SPAN>(Sum({&lt;GL_1 = {VOL}, Dimension = {RFC}&gt;} Data), 0, <SPAN style="color: #ff0000;">RowNo</SPAN>()))</STRONG></P></BODY></HTML> Wed, 19 Jul 2017 12:35:14 GMT https://community.qlik.com/t5/QlikView/How-to-do-a-YTD-calculation/m-p/1335101#M825110 sunny_talwar 2017-07-19T12:35:14Z Re: How to do a YTD calculation https://community.qlik.com/t5/QlikView/How-to-do-a-YTD-calculation/m-p/1335102#M825111 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny! It worked!</P></BODY></HTML> Wed, 19 Jul 2017 12:38:08 GMT https://community.qlik.com/t5/QlikView/How-to-do-a-YTD-calculation/m-p/1335102#M825111 tim_leijen 2017-07-19T12:38:08Z