topic Running Total - pick match in QlikView https://community.qlik.com/t5/QlikView/Running-Total-pick-match/m-p/167472#M39029 <HTML><HEAD></HEAD><BODY><P>Have created the attached file using pick match functionality.</P><P>Want to add a running total column to the right but am unsure of the syntax.</P><P>Can anyone help?</P></BODY></HTML> Mon, 01 Nov 2010 22:35:56 GMT pkelly 2010-11-01T22:35:56Z Running Total - pick match https://community.qlik.com/t5/QlikView/Running-Total-pick-match/m-p/167472#M39029 <HTML><HEAD></HEAD><BODY><P>Have created the attached file using pick match functionality.</P><P>Want to add a running total column to the right but am unsure of the syntax.</P><P>Can anyone help?</P></BODY></HTML> Mon, 01 Nov 2010 22:35:56 GMT https://community.qlik.com/t5/QlikView/Running-Total-pick-match/m-p/167472#M39029 pkelly 2010-11-01T22:35:56Z Running Total - pick match https://community.qlik.com/t5/QlikView/Running-Total-pick-match/m-p/167473#M39030 <HTML><HEAD></HEAD><BODY><P>Change this part as indicated:</P><P style="padding-left:30px;">NUM(RANGESUM(SUM(ins_Sales),ABOVE(COLUMN(1))), '#,##0'),<BR />NUM(RANGESUM(SUM(ins_GrossProfit),ABOVE(COLUMN(1))), '#,##0'))</P><P>Another approach would be an AsOf table that connects the current period to all previous periods. You might want something like that if you're going to allow pivoting. The other answer would be to turn off pivoting so the user can't mess up the above() function.</P></BODY></HTML> Mon, 01 Nov 2010 22:51:08 GMT https://community.qlik.com/t5/QlikView/Running-Total-pick-match/m-p/167473#M39030 johnw 2010-11-01T22:51:08Z