Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Coolavin
Partner - Contributor III
Partner - Contributor III

Moving Averages on a line graph?

Hello,

I need to create a moving averages report in Qlik Sense that uses a line chart and looks some what like the image below. 

There are two data points: "Exam scores" and "attempts". 

Within a selectable time period for the first 1-30 attempts it finds the average and plots it on the graph. 

Then for the next one it should find the average for 2-31 and plot it on the graph

and then for 3-32 and so on to the last exam score.

Is this something that is dynamically possible? Would you use the RangeAvg function? If so, how would you do it? If not what would you use? Thank you for your help. 

moving averages.png

Labels (1)
0 Replies