topic Re: Cumulative Percentage to Target in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Percentage-to-Target/m-p/1245605#M623633 <HTML><HEAD></HEAD><BODY><P>What are your expressions here? Assuming you have Sum(Sales), try this</P><P></P><P><STRONG>RangeSum(Above(Sum(Sales), 0, RowNo()))/Sum(TOTAL Sales)</STRONG></P></BODY></HTML> Mon, 14 Nov 2016 13:04:31 GMT sunny_talwar 2016-11-14T13:04:31Z Cumulative Percentage to Target https://community.qlik.com/t5/QlikView/Cumulative-Percentage-to-Target/m-p/1245604#M623632 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Please have a look at the attached graph&nbsp; and data.I am trying to calculate Cumulative % to target based on this data, I have tried using' Full Accumulation' option but it's not correct.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Mon, 14 Nov 2016 12:58:30 GMT https://community.qlik.com/t5/QlikView/Cumulative-Percentage-to-Target/m-p/1245604#M623632 2016-11-14T12:58:30Z Re: Cumulative Percentage to Target https://community.qlik.com/t5/QlikView/Cumulative-Percentage-to-Target/m-p/1245605#M623633 <HTML><HEAD></HEAD><BODY><P>What are your expressions here? Assuming you have Sum(Sales), try this</P><P></P><P><STRONG>RangeSum(Above(Sum(Sales), 0, RowNo()))/Sum(TOTAL Sales)</STRONG></P></BODY></HTML> Mon, 14 Nov 2016 13:04:31 GMT https://community.qlik.com/t5/QlikView/Cumulative-Percentage-to-Target/m-p/1245605#M623633 sunny_talwar 2016-11-14T13:04:31Z