Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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