rangesum movil sum

dcd123456 — Fri, 02 Mar 2018 17:37:01 GMT

Hello

I have a table with timestamps and value. for example

stamp	Value
6:05:00	39,41
6:12:35	27,93
6:20:10	25,13
6:27:45	21,2
6:35:21	19,94
6:39:43	29,54
6:44:06	107,85
6:48:28	24,37
6:52:51	40,8
6:57:14	100,55
7:01:36	58,09
7:05:03	89,2
7:08:30	51,45
7:11:57	81,24
7:15:24	58,11
7:18:51	66,5
7:22:18	76,02
7:25:44	97,27
7:29:11	125,55
7:32:38	50,12
7:35:48	70,81
7:38:58	99,11

i need to create a new column, each value in the new colum must be the sum of the above values of the field Value but only of the revords where the stamp time is lower than 60 minutes of the first record.

For excample in the above table, the new value of the record 1 will be the sum of the above records records where the stamp is lower than 6:05:00 + 60 minutes --> 7:05:00, and so it must sum the values from 39,41 (stamp = 39,41) to 58,09 (stamp 7:01:36).

In the secord rows the same, the new value field must sum the values from 27,93 (stamp 6:12:35) to the value 81,24(stamp 7:11:57)

and so on....

stamp	Value	NewSum Value
6:05:00	39,41	494,81
6:12:35	27,93	677,29
6:20:10	25,13	773,97
6:27:45	21,2	….
6:35:21	19,94
6:39:43	29,54
6:44:06	107,85
6:48:28	24,37
6:52:51	40,8
6:57:14	100,55
7:01:36	58,09
7:05:03	89,2
7:08:30	51,45
7:11:57	81,24
7:15:24	58,11
7:18:51	66,5
7:22:18	76,02
7:25:44	97,27
7:29:11	125,55
7:32:38	50,12
7:35:48	70,81
7:38:58	99,11
7:42:08	140,6
7:45:17	164,24
7:48:27	59,69
7:51:37	80,4

is there a way to do this in the scrip or in a graph expresion using rangesum or other function

thanks in advance for your help

regards

Re: rangesum movil sum

dcd123456 — Mon, 05 Mar 2018 12:15:55 GMT

Anyone know if there is a way to use rangesum with above function but filtering the records that above function must take, for example filtering by the value of other field.

Thanks in advance

regards

Re: rangesum movil sum

jerryyang756 — Mon, 05 Mar 2018 12:46:46 GMT

Dimension : stamp

Expression:

1) Sum(Value)

2) If(stamp < '7:05:00', Rangesum(Above(Sum(Value),0,RowNo(TOTAL))))

topic Re: rangesum movil sum in QlikView

rangesum movil sum

Re: rangesum movil sum

Re: rangesum movil sum