topic Cumulative Expression in Graph in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Expression-in-Graph/m-p/1221705#M848990 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to do an acummulative expresion in a graph from the expression: Sum(distinct sales).</P><P></P><P>the only dimension in the graph is year.</P><P></P><P>hoping you can help me</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Cumulative Expression in Graph https://community.qlik.com/t5/QlikView/Cumulative-Expression-in-Graph/m-p/1221705#M848990 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to do an acummulative expresion in a graph from the expression: Sum(distinct sales).</P><P></P><P>the only dimension in the graph is year.</P><P></P><P>hoping you can help me</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cumulative-Expression-in-Graph/m-p/1221705#M848990 Anonymous 2020-11-25T16:16:04Z Re: Cumulative Expression in Graph https://community.qlik.com/t5/QlikView/Cumulative-Expression-in-Graph/m-p/1221706#M848991 <HTML><HEAD></HEAD><BODY><P>rangesum(above(sum(distinct sales),0,RowNo()))</P></BODY></HTML> Thu, 16 Mar 2017 17:14:51 GMT https://community.qlik.com/t5/QlikView/Cumulative-Expression-in-Graph/m-p/1221706#M848991 Anonymous 2017-03-16T17:14:51Z Re: Cumulative Expression in Graph https://community.qlik.com/t5/QlikView/Cumulative-Expression-in-Graph/m-p/1221707#M848992 <HTML><HEAD></HEAD><BODY><P>Its not a good idea to do distinct sum of sales... What if you have data like this</P><P></P><P>Year&nbsp;&nbsp;&nbsp;&nbsp; Employee&nbsp;&nbsp;&nbsp; Sales</P><P>2010 Shyam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>2010&nbsp;&nbsp;&nbsp;&nbsp; Ram&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>2010&nbsp;&nbsp;&nbsp;&nbsp; Rakesh&nbsp;&nbsp;&nbsp;&nbsp; 70</P><P></P><P>Sum(DISTINCT Sales) = 120, I don't think you would want this, do you?</P></BODY></HTML> Thu, 16 Mar 2017 17:35:13 GMT https://community.qlik.com/t5/QlikView/Cumulative-Expression-in-Graph/m-p/1221707#M848992 sunny_talwar 2017-03-16T17:35:13Z