topic Re: Running toal in QlikView https://community.qlik.com/t5/QlikView/Running-toal/m-p/37271#M6290 <HTML><HEAD></HEAD><BODY><P>PFA Solution</P></BODY></HTML> Sun, 15 Apr 2018 08:06:42 GMT passionate 2018-04-15T08:06:42Z Running toal https://community.qlik.com/t5/QlikView/Running-toal/m-p/37270#M6289 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Need help to populate running total in straight table with 2 dimensions. Attached sample qlikview application.</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 412px;"><TBODY><TR><TD class="xl65" height="17" width="103">Dim1</TD><TD class="xl65" style="border-left: none;" width="103">Dim2</TD><TD class="xl65" style="border-left: none;" width="103">Sum</TD><TD class="xl65" style="border-left: none;" width="103"><STRONG>Running total</STRONG></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">A</TD><TD class="xl66" style="border-top: none; border-left: none;">a</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">6863</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">6863</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">A</TD><TD class="xl66" style="border-top: none; border-left: none;">b</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">21689</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">28552</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">B</TD><TD class="xl66" style="border-top: none; border-left: none;">c</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">38056</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">66608</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">B</TD><TD class="xl66" style="border-top: none; border-left: none;">d</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">49385</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">115993</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">C</TD><TD class="xl66" style="border-top: none; border-left: none;">e</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">60542</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">176535</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">C</TD><TD class="xl66" style="border-top: none; border-left: none;">f</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">69069</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">245604</TD></TR></TBODY></TABLE><P></P><P>Thank you !<SPAN style="font-family: inherit; font-style: inherit; font-weight: inherit; font-size: 10pt;">and looking forward to hearing from anyone</SPAN></P></BODY></HTML> Sun, 15 Apr 2018 07:32:07 GMT https://community.qlik.com/t5/QlikView/Running-toal/m-p/37270#M6289 vikram_patro 2018-04-15T07:32:07Z Re: Running toal https://community.qlik.com/t5/QlikView/Running-toal/m-p/37271#M6290 <HTML><HEAD></HEAD><BODY><P>PFA Solution</P></BODY></HTML> Sun, 15 Apr 2018 08:06:42 GMT https://community.qlik.com/t5/QlikView/Running-toal/m-p/37271#M6290 passionate 2018-04-15T08:06:42Z Re: Running toal https://community.qlik.com/t5/QlikView/Running-toal/m-p/37272#M6291 <HTML><HEAD></HEAD><BODY><P>Use this expression for Running Total</P><P></P><P><STRONG>RangeSum(Above(TOTAL SUM(Expression1),0,RowNo(TOTAL)))</STRONG></P></BODY></HTML> Sun, 15 Apr 2018 09:14:03 GMT https://community.qlik.com/t5/QlikView/Running-toal/m-p/37272#M6291 MK_QSL 2018-04-15T09:14:03Z Re: Running toal https://community.qlik.com/t5/QlikView/Running-toal/m-p/37273#M6292 <HTML><HEAD></HEAD><BODY><P>Please close the thread by marking answer correct if your query is resolved.</P></BODY></HTML> Mon, 16 Apr 2018 11:42:25 GMT https://community.qlik.com/t5/QlikView/Running-toal/m-p/37273#M6292 passionate 2018-04-16T11:42:25Z