topic Re: Simple running total Question in QlikView https://community.qlik.com/t5/QlikView/Simple-running-total-Question/m-p/375534#M139910 <HTML><HEAD></HEAD><BODY><P>Thanks Ioannis, however the Total colum just displays the same value for the Value column. Is there anything else I need to set-up?</P></BODY></HTML> Mon, 02 Jul 2012 12:37:37 GMT 2012-07-02T12:37:37Z Simple running total Question https://community.qlik.com/t5/QlikView/Simple-running-total-Question/m-p/375532#M139908 <HTML><HEAD></HEAD><BODY><P>I am new to Qlikview and just experimenting with simple data. I have loaded a table with three columns: Date, Name and Value. I want to create a straight table which displays me a running total (Total) by Date and Name. </P><P></P><P>However the following expression does not work for me. rangesum(sum("Value"),above("Total"))<STRONG><SPAN style="color: #800080; font-size: 8pt;"> </SPAN></STRONG></P><P></P><P></P><P></P><P></P></BODY></HTML> Mon, 02 Jul 2012 11:00:55 GMT https://community.qlik.com/t5/QlikView/Simple-running-total-Question/m-p/375532#M139908 2012-07-02T11:00:55Z Re: Simple running total Question https://community.qlik.com/t5/QlikView/Simple-running-total-Question/m-p/375533#M139909 <HTML><HEAD></HEAD><BODY><P>try <SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">rangesum(sum("Value"),above(<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">sum("Value"</SPAN>))</SPAN></P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">or better rangesum(above(sum("Value"), 0, rowno()))<BR /></SPAN></P></BODY></HTML> Mon, 02 Jul 2012 11:33:36 GMT https://community.qlik.com/t5/QlikView/Simple-running-total-Question/m-p/375533#M139909 giakoum 2012-07-02T11:33:36Z Re: Simple running total Question https://community.qlik.com/t5/QlikView/Simple-running-total-Question/m-p/375534#M139910 <HTML><HEAD></HEAD><BODY><P>Thanks Ioannis, however the Total colum just displays the same value for the Value column. Is there anything else I need to set-up?</P></BODY></HTML> Mon, 02 Jul 2012 12:37:37 GMT https://community.qlik.com/t5/QlikView/Simple-running-total-Question/m-p/375534#M139910 2012-07-02T12:37:37Z Re: Simple running total Question https://community.qlik.com/t5/QlikView/Simple-running-total-Question/m-p/375535#M139911 <HTML><HEAD></HEAD><BODY><P>Actually swappign the name and Date dimensions, this works</P></BODY></HTML> Mon, 02 Jul 2012 12:57:17 GMT https://community.qlik.com/t5/QlikView/Simple-running-total-Question/m-p/375535#M139911 2012-07-02T12:57:17Z