topic Rolling average line graph in App Development

Rolling average line graph

Bart_Breekveldt — Sat, 16 Nov 2024 20:09:06 GMT

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 — Wed, 04 Sep 2019 09:30:39 GMT

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 — Thu, 05 Sep 2019 12:53:48 GMT

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 — Thu, 05 Sep 2019 15:18:51 GMT

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