https://community.qlik.com/t5/App-Development/Cumulative-percentage-with-Rangesum-problem-with-set-analysis/m-p/1807467#M65726 <P>Hi, I'm having some trouble with a rangesum that calculates a cumulative percentage and trying to apply set analysis.&nbsp; This is used in a chart to show a percent that met a criteria against the total set.&nbsp; The data was being filtered in the load script to just take the last 7 days and worked as expected in this case.&nbsp; Request was made for an additional view over 6 months so I changed the load script to bring in 6 months of data and added a field that gets set as an indicator if the data is within the last 7 days thinking I just needed to add some simple set analysis to the original chart.&nbsp; When I did this, it only calculates the values for the last 7 days correctly but I get an entry for every date, not jus the ones that meet the set analysis criteria.&nbsp; I don't want all the extra dates that show zeros.</P><P>In this image the chart shows the dates with no values, highlighted in yellow.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wayneantinore-a_0-1620844808402.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54840iF1325ED8319E29D8/image-size/medium?v=v2&amp;px=400" role="button" title="wayneantinore-a_0-1620844808402.png" alt="wayneantinore-a_0-1620844808402.png" /></span></P><P>This is the rangesum function with the set analysis</P><P>Rangesum(above(Count({$&lt;Last7Days={'Y'}&gt;}[Order#])/ Aggr(nodistinct Count({$&lt;Last7Days={'Y'}&gt;}[Order#]),[Date Received]),0,RowNo()))</P><P>I've changed the set analysis condition to look at the [Date Received] field specifically and get the same results.&nbsp; If I remove the set analysis condition from the Aggr I get the same results so it's like it doesn't even apply the set analysis there.&nbsp; Thanks in advance for any help.</P> Wed, 12 May 2021 18:45:59 GMT wayne-a 2021-05-12T18:45:59Z https://community.qlik.com/t5/App-Development/Cumulative-percentage-with-Rangesum-problem-with-set-analysis/m-p/1807467#M65726 <P>Hi, I'm having some trouble with a rangesum that calculates a cumulative percentage and trying to apply set analysis.&nbsp; This is used in a chart to show a percent that met a criteria against the total set.&nbsp; The data was being filtered in the load script to just take the last 7 days and worked as expected in this case.&nbsp; Request was made for an additional view over 6 months so I changed the load script to bring in 6 months of data and added a field that gets set as an indicator if the data is within the last 7 days thinking I just needed to add some simple set analysis to the original chart.&nbsp; When I did this, it only calculates the values for the last 7 days correctly but I get an entry for every date, not jus the ones that meet the set analysis criteria.&nbsp; I don't want all the extra dates that show zeros.</P><P>In this image the chart shows the dates with no values, highlighted in yellow.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wayneantinore-a_0-1620844808402.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54840iF1325ED8319E29D8/image-size/medium?v=v2&amp;px=400" role="button" title="wayneantinore-a_0-1620844808402.png" alt="wayneantinore-a_0-1620844808402.png" /></span></P><P>This is the rangesum function with the set analysis</P><P>Rangesum(above(Count({$&lt;Last7Days={'Y'}&gt;}[Order#])/ Aggr(nodistinct Count({$&lt;Last7Days={'Y'}&gt;}[Order#]),[Date Received]),0,RowNo()))</P><P>I've changed the set analysis condition to look at the [Date Received] field specifically and get the same results.&nbsp; If I remove the set analysis condition from the Aggr I get the same results so it's like it doesn't even apply the set analysis there.&nbsp; Thanks in advance for any help.</P> Wed, 12 May 2021 18:45:59 GMT https://community.qlik.com/t5/App-Development/Cumulative-percentage-with-Rangesum-problem-with-set-analysis/m-p/1807467#M65726 wayne-a 2021-05-12T18:45:59Z https://community.qlik.com/t5/App-Development/Cumulative-percentage-with-Rangesum-problem-with-set-analysis/m-p/1807488#M65729 <P>Have you tried un-setting the "Data handling"-&gt;"Include zero values" or in the dimension use an expression and suppress Nulls</P><P>If (Last7Days='Y',[Date Received],Null())&nbsp;</P><P>&nbsp;</P> Wed, 12 May 2021 19:37:12 GMT https://community.qlik.com/t5/App-Development/Cumulative-percentage-with-Rangesum-problem-with-set-analysis/m-p/1807488#M65729 jwjackso 2021-05-12T19:37:12Z https://community.qlik.com/t5/App-Development/Cumulative-percentage-with-Rangesum-problem-with-set-analysis/m-p/1807693#M65745 <P>Jwjackso thank you very much!&nbsp; Setting the Data handling to not include zero values did it.&nbsp; I completely missed that option.</P> Thu, 13 May 2021 10:57:07 GMT https://community.qlik.com/t5/App-Development/Cumulative-percentage-with-Rangesum-problem-with-set-analysis/m-p/1807693#M65745 wayne-a 2021-05-13T10:57:07Z