Rolling average line graph

[Bart_Breekveldt]

Dear community,

I have a Range Avg measure to determine the five week rolling average for the order amount of pieces per tray in a table. The measure is as follows:

RangeAvg(Above(Aggr(Sum(Amount*Pieces_perTray),[Order.delivery_date.autoCalendar.YearWeek]),0,5))

For example:

Week, amount, rolling average

W-01 2, 2 

W-02 5, 3.5

W-03 3, 3.33

W-04 9, 4.75

W-05 11, 6

W-06 4, 6.4

etc.

However it gives an error when I put this measure into a line chart. How do I change the formula to fit as a measure in a line chart?

Thanks in advance

[Seyko · Accepted solution]

Hello,

I haven't modified anything, your calculation works for me (see the screenshot). What error is exactly returned (join a screenshot)?

cordially.

[Bart_Breekveldt]

Shortly after this post, I got an error in de Qlik Sense Server, now it works. I think it had to do with that error. Thanks for your effort.

[Seyko]

Yu're welcome. However, don't forget to mark your post like resolved.