Discussion board where members can learn more about Qlik Sense App Development and Usage.
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:
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
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
I haven't modified anything, your calculation works for me (see the screenshot). What error is exactly returned (join a screenshot)?
View solution in original post
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.
Yu're welcome. However, don't forget to mark your post like resolved.