Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Sum a field by period in a script

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.  I want to have the value for period"x" to be total of x down to 1 peiords summed.  How do I do this in the script?Example with 3 periods.  First period feild value is 3 so total of it and all previous should be 3.  Second period field value is 1 so total of it and all previous is 4.  Thrid period field value is 5 so the total of it and all previous is 9.  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.

1 Reply
sivarajs
Valued Contributor II

Re: Sum a field by period in a script

attached file may give you the idea to proceed further

Community Browser