Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
grajmca_sgp123
Creator
Creator

Moving avg by each month with in Quarter

Hi Team,

I have a requirement to find moving avg value by each month within quarter.

Below is sample data with expected output of Moving Avg of output field. Can you please help me with solution.

Reporting_date Amount Qtr-Start Moving Avg(Output value)
25-Mar 100 1-Jan 100
31-Mar 120 1-Jan 110
4-Apr 105 1-Apr 105
10-Apr 107 1-Apr 106
31-Apr 109 1-Apr 107
4-May 130 1-Apr 112.75
29-Jun 119 1-Apr 114
30-Jun 122 1-Apr 115.33
1-Jul 101 1-Jul 101

 

Thank you

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

HI

Try like below
Dim: Qtr-Start
Dim2: Reporting_date
Exp1: Sum(Amount)
Exp2:RangeAvg(Above(Sum(Amount),0, RowNo()))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

HI

Try like below
Dim: Qtr-Start
Dim2: Reporting_date
Exp1: Sum(Amount)
Exp2:RangeAvg(Above(Sum(Amount),0, RowNo()))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.