How to implement running total in date range for each group in script load

Anonymous — Fri, 24 Nov 2017 09:31:09 GMT

Dear All, I have a problem in running total data in script load.

So have any solution for this case or not?

My data like below:

Data2:

Load * Inline [

date, flag, pic

1, 1, a

2, 1, a

4, 0, a

5, 0, a

7, 1, a

9, 1, a

10, 1, a

1, 0, b

2, 1, b

3, 1, b

4, 1, b

5, 0, b

6, 0, b

3, 0, c

4, 1, c

5, 1, c

6, 0, c

7, 0, c

];

My problem: Generate field [flag within 3 previous days] : at current row of [date] field, mark 1 for [flag within 3 previous days] if in 3 previous days have [flag]=1 for each group of [pic]

My expected result:

date	pic	flag	flag within 3 previous days
1	a	1	1
2	a	1	1
3	a	1	1
4	a	1	1
5	a	0	0
6	a	0	0
7	a	1	1
8	a	1	1
9	a	1	1
10	a	1	1
1	b	0	0
2	b	1	1
3	b	1	1
4	b	1	1
5	b	1	1
6	b	1	1
7	b	0	0
8	b	0	0
3	c	0	0
4	c	1	1
5	c	1	1
6	c	1	1
7	c	1	1
8	c	0	0
9	c	0	0

topic How to implement running total in date range for each group in script load in QlikView

How to implement running total in date range for each group in script load