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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
maxattar
Partner - Contributor II
Partner - Contributor II

In a chart table, average over previous 3 months for each row

Hi experts,

Can you help me achieve the following : 

I want to calculate the average score over a period of 3 months for each row of a table containing the age of the player at which the score was done, the date of the score and the score itself.

How could I achieve such thing (in the sheet itself or in the load script) not using As Of table (which I can't use because of what I want to do next : show each of these average scores for each player in a bar graph where the dimension is not the date of the score but the age at which the players achieved the scores).

avg_over_3_months.png

I managed to do it for the last 3 months before today using the following measure : 

{<Score_date={">=$(=AddMonths(Today(),-3))"}>}Avg(Score) but can't do it for all of the scores before this period.

Thanks a lot !

Labels (1)
0 Replies