Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Bart_Breekveldt
Contributor III
Contributor III

Rolling average line graph

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

Labels (5)
1 Solution

Accepted Solutions
Seyko
Partner
Partner

Hello,

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

cordially.

Excuse my english, i'm french!

View solution in original post

3 Replies
Seyko
Partner
Partner

Hello,

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

cordially.

Excuse my english, i'm french!

View solution in original post

Bart_Breekveldt
Contributor III
Contributor III
Author

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
Partner
Partner

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

Excuse my english, i'm french!