topic Rolling Seasonal Average in App Development https://community.qlik.com/t5/App-Development/Rolling-Seasonal-Average/m-p/1998123#M82662 <P>Hi,</P> <P>I need to do some set analysis on a data set where I need to count the values in a field by this year/month, the same month last year and the same month 2 years ago, effectively giving me a month average. I have a date field (in 'dd/MM/YYYY' format) and also a Year/Month field (in 'MM/YYYY') format. My dimension is currently by the Year/Month field and measure is the count of values. The graph I am trying to replicate is below and the Rolling Seasonal Average is the line I am trying to replicate.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot.png" style="width: 827px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92405i24C8C12FAF4BDF81/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot.png" alt="Screenshot.png" /></span></P> <P>Any assistance would be greatly appreciated!</P> <P>Many thanks!</P> Fri, 28 Oct 2022 13:53:56 GMT jamesbruty 2022-10-28T13:53:56Z Rolling Seasonal Average https://community.qlik.com/t5/App-Development/Rolling-Seasonal-Average/m-p/1998123#M82662 <P>Hi,</P> <P>I need to do some set analysis on a data set where I need to count the values in a field by this year/month, the same month last year and the same month 2 years ago, effectively giving me a month average. I have a date field (in 'dd/MM/YYYY' format) and also a Year/Month field (in 'MM/YYYY') format. My dimension is currently by the Year/Month field and measure is the count of values. The graph I am trying to replicate is below and the Rolling Seasonal Average is the line I am trying to replicate.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot.png" style="width: 827px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92405i24C8C12FAF4BDF81/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot.png" alt="Screenshot.png" /></span></P> <P>Any assistance would be greatly appreciated!</P> <P>Many thanks!</P> Fri, 28 Oct 2022 13:53:56 GMT https://community.qlik.com/t5/App-Development/Rolling-Seasonal-Average/m-p/1998123#M82662 jamesbruty 2022-10-28T13:53:56Z