Accumulation Count in Script

[Purushothaman]

Hi,

I have a table with Client code and dates and Account Status

How can I accumulate the data by throughout the Date Field by ClientCode where Account Status = A

For example we have a table with the data:

dd/mm/yyyy	Client Code	Account Status
1/1/2010	C1	A
1/1/2010	C2	C
2/1/2010	C3	A
2/1/2010	C4	C
15/1/2010	C5	C
16/1/2010	C6	A
17/1/2010	C7	A
20/1/2010	C8	C
21/1/2010	C9	C
3/2/2010	C10	A
4/2/2010	C11	A
27/2/2010	C12	C
27/2/2010	C13	A
9/3/2010	C14	C
9/3/2010	C15	A
18/3/2010	C16	A
19/1/2011	C18	A
20/2/2011	C19	C
11/6/2011	C20	A

My Requirement is:

If I select 'Jan 2010' I should get 4,

If I select 'Feb 2010' I should get 7,

If I select 'Mar 2010' I should get 9

and 

If I select 'Jan 2010' I should get 10

How can we do this in Qlik Sense backend in the Script?

Anyone, Please help!!

Thank you.

[hic · Accepted solution]

Assuming that the records are ordered by date:

Load
Date,
[Client Code],
[Account Status],
RangeSum(If([Account Status]='A',1,0),Peek(Count)) as Count
From ...