topic Re: Sum a field by period in a script in QlikView https://community.qlik.com/t5/QlikView/Sum-a-field-by-period-in-a-script/m-p/330613#M705063 <HTML><HEAD></HEAD><BODY><P>attached file may give you the idea to proceed further</P></BODY></HTML> Wed, 02 May 2012 12:48:16 GMT sivarajs 2012-05-02T12:48:16Z Sum a field by period in a script https://community.qlik.com/t5/QlikView/Sum-a-field-by-period-in-a-script/m-p/330612#M705062 <HTML><HEAD></HEAD><BODY><P> Hi Community,I have a field that I would like to sum the values of in a period to get the total of all previous periods combined.The period ranges from 1 to 26 and is called Period Number.&nbsp; I want to have the value for period"x" to be total of x down to 1 peiords summed.&nbsp; How do I do this in the script?Example with 3 periods.&nbsp; First period feild value is 3 so total of it and all previous should be 3.&nbsp; Second period field value is 1 so total of it and all previous is 4.&nbsp; Thrid period field value is 5 so the total of it and all previous is 9.&nbsp; I want to make a total so that any period I select, I can see the total of it and all the previous of the selection.</P></BODY></HTML> Tue, 01 May 2012 17:57:21 GMT https://community.qlik.com/t5/QlikView/Sum-a-field-by-period-in-a-script/m-p/330612#M705062 2012-05-01T17:57:21Z Re: Sum a field by period in a script https://community.qlik.com/t5/QlikView/Sum-a-field-by-period-in-a-script/m-p/330613#M705063 <HTML><HEAD></HEAD><BODY><P>attached file may give you the idea to proceed further</P></BODY></HTML> Wed, 02 May 2012 12:48:16 GMT https://community.qlik.com/t5/QlikView/Sum-a-field-by-period-in-a-script/m-p/330613#M705063 sivarajs 2012-05-02T12:48:16Z