topic Running Total In Script in QlikView https://community.qlik.com/t5/QlikView/Running-Total-In-Script/m-p/142302#M21791 <HTML><HEAD></HEAD><BODY><P>It works, reading from your file.</P><P>Beware: field names are case sensitive !</P><P>Sempre fi,<BR />Cotiso</P><P><STRONG>load *</STRONG><STRONG>,<BR /> I</STRONG>F ([Account Code]=peek([Account Code]), (Amount + peek(RAMOUNT)),Amount) AS RAMOUNT;<BR /><BR />LOAD [Account Code]<STRONG>, Yearmm</STRONG>, Amount, <STRONG>[What I want]<BR />FROM</STRONG> .\Data.xls (biff, embedded labels, table is Sheet1$);</P><P></P><P></P><P></P><BR /><BR /> <BR /><BR /> <P></P><P></P><P></P><BR /><BR /> <BR /><BR /></BODY></HTML> Fri, 24 Apr 2009 14:08:19 GMT cotiso_hanganu 2009-04-24T14:08:19Z Running Total In Script https://community.qlik.com/t5/QlikView/Running-Total-In-Script/m-p/142301#M21790 <HTML><HEAD></HEAD><BODY><P>Hai,</P><P></P><P>I'm trying to get the running in total in script.Please refer my atatchment.Also i 've tried with the following script:</P><P></P><P>IF(ACCOUNT=PEEK(ACCOUNT), ([AMOUNT] + PEEK(RAMOUNT)),[AMOUNT]) AS RAMOUNT</P><P></P><P>Please do the needul..</P><P></P><P>Thanks in Advance..</P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 24 Apr 2009 13:22:34 GMT https://community.qlik.com/t5/QlikView/Running-Total-In-Script/m-p/142301#M21790 2009-04-24T13:22:34Z Running Total In Script https://community.qlik.com/t5/QlikView/Running-Total-In-Script/m-p/142302#M21791 <HTML><HEAD></HEAD><BODY><P>It works, reading from your file.</P><P>Beware: field names are case sensitive !</P><P>Sempre fi,<BR />Cotiso</P><P><STRONG>load *</STRONG><STRONG>,<BR /> I</STRONG>F ([Account Code]=peek([Account Code]), (Amount + peek(RAMOUNT)),Amount) AS RAMOUNT;<BR /><BR />LOAD [Account Code]<STRONG>, Yearmm</STRONG>, Amount, <STRONG>[What I want]<BR />FROM</STRONG> .\Data.xls (biff, embedded labels, table is Sheet1$);</P><P></P><P></P><P></P><BR /><BR /> <BR /><BR /> <P></P><P></P><P></P><BR /><BR /> <BR /><BR /></BODY></HTML> Fri, 24 Apr 2009 14:08:19 GMT https://community.qlik.com/t5/QlikView/Running-Total-In-Script/m-p/142302#M21791 cotiso_hanganu 2009-04-24T14:08:19Z