topic RangeAVG rolling on 7 days in QlikView

RangeAVG rolling on 7 days

Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I have been looking around (help and community) and could not find the exactly answer I have been looking for. Here is an example of the graph I am trying to achieve in QlikView with a set of data attached to this discussion. Basically, I want 3 moving average (HDOR, LDOR and MD) with a range of 7 days. The number of data point is different between HDOR, LDOR and MD and also change from week to week. I would love moving away from my macro

Thanks for your help

Re: RangeAVG rolling on 7 days

settu_periasamy — Fri, 08 Apr 2016 03:02:15 GMT

Hi,

Something like this?

Re: RangeAVG rolling on 7 days

Gysbert_Wassenaar — Fri, 08 Apr 2016 06:35:55 GMT

See attached example. Perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations

Re: RangeAVG rolling on 7 days

Fri, 08 Apr 2016 16:49:11 GMT

This look like it but it is not exactly what I am looking for. In this case the interval of 7 days is fixed and there is only one average per 7 days. I need one average per data entry rolling back 7 days. My goal is to monitor the performance and eventually add alert when we are outside a given threshold. Through the day, new tests are reported and this table will be updated frequently.

Re: RangeAVG rolling on 7 days

Fri, 08 Apr 2016 16:56:23 GMT

Yes, I did look at this before posting. In that example you have one data entry per month, in my case I have multiple entry for each day and that number of entry is not fixed. I did tried a few things but I got confused, probably because I am new to QV functions.

I think in my case it would be easier if I set a fixed interval but ideally using the weekly moving average is much better.

Thanks

Re: RangeAVG rolling on 7 days

Gysbert_Wassenaar — Fri, 08 Apr 2016 17:52:31 GMT

In that example you have one data entry per month, in my case I have multiple entry for each day and that number of entry is not fixed.

I don't see the problem. Just sum the values and divide the result by seven.