https://community.qlik.com/t5/QlikView/RangeAvg-to-be-calculated-for-a-column-based-on-a-range/m-p/1685681#M450368 <P>I have a Shipment Count chart table consisting of the dimensions [Day Month], [year] and the expression [Count] which is a count of individual shipments for each [Day Month] (eg. "25 Feb"") and [year] (specifically 2019 and then 2020). I have just added a new expression "RangeAvg (Above(Count,0,RowNo()))" which does a RangeAvg for all the values in the [Count] field. For the first [Count] field value (top row), the RangeAvg will equal the [Count] field value, but starting with the second [Count] field, the RangeAvg does an average of that field and all the ones above it.</P><P>Here is my question: Since my data runs across 2 years (2019 and 2020) and does NOT include all months in each year (its only 18 Feb to 17 Mar for each year), I want the RangeAvg function to restart from zero once it crosses from a row with year=2019 to a row with year=2020. So in a sense I want to group my data by year with regard to RangeAvg.</P><P>How can I accomplish this?</P><P>Thanks</P><P>Jason</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 01:01:47 GMT Jason1 2024-11-16T01:01:47Z https://community.qlik.com/t5/QlikView/RangeAvg-to-be-calculated-for-a-column-based-on-a-range/m-p/1685681#M450368 <P>I have a Shipment Count chart table consisting of the dimensions [Day Month], [year] and the expression [Count] which is a count of individual shipments for each [Day Month] (eg. "25 Feb"") and [year] (specifically 2019 and then 2020). I have just added a new expression "RangeAvg (Above(Count,0,RowNo()))" which does a RangeAvg for all the values in the [Count] field. For the first [Count] field value (top row), the RangeAvg will equal the [Count] field value, but starting with the second [Count] field, the RangeAvg does an average of that field and all the ones above it.</P><P>Here is my question: Since my data runs across 2 years (2019 and 2020) and does NOT include all months in each year (its only 18 Feb to 17 Mar for each year), I want the RangeAvg function to restart from zero once it crosses from a row with year=2019 to a row with year=2020. So in a sense I want to group my data by year with regard to RangeAvg.</P><P>How can I accomplish this?</P><P>Thanks</P><P>Jason</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 01:01:47 GMT https://community.qlik.com/t5/QlikView/RangeAvg-to-be-calculated-for-a-column-based-on-a-range/m-p/1685681#M450368 Jason1 2024-11-16T01:01:47Z https://community.qlik.com/t5/QlikView/RangeAvg-to-be-calculated-for-a-column-based-on-a-range/m-p/1685689#M450369 <P>Seems like it is already resetting, isn't it?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 548px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30221i8BCB25A0DFD9B537/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>If it was not resetting, you would have seen a different number for 18Feb and not 106 which is equal to the count of 106, right?</P> Wed, 18 Mar 2020 12:39:08 GMT https://community.qlik.com/t5/QlikView/RangeAvg-to-be-calculated-for-a-column-based-on-a-range/m-p/1685689#M450369 sunny_talwar 2020-03-18T12:39:08Z https://community.qlik.com/t5/QlikView/RangeAvg-to-be-calculated-for-a-column-based-on-a-range/m-p/1685699#M450370 <P>Thanks for pointing that out! I did just see it myself and was about to post.</P> Wed, 18 Mar 2020 13:03:48 GMT https://community.qlik.com/t5/QlikView/RangeAvg-to-be-calculated-for-a-column-based-on-a-range/m-p/1685699#M450370 Jason1 2020-03-18T13:03:48Z