topic Rangesum / Above in Line Chart in App Development https://community.qlik.com/t5/App-Development/Rangesum-Above-in-Line-Chart/m-p/1645489#M48123 <P>Hi all,</P><P>I'm running into trouble presenting a cumulative sum broken down by a dimension in a line chart.&nbsp;</P><P>I would like the following for "Cumulative Value". My current formula is rangesum(above(sum(Value), 0,3)), and it works in table form when you sort by Tier, and in the line chart when the primary dimension is Tier and the secondary is Month.</P><TABLE border="1"><TBODY><TR><TD>Month</TD><TD>Tier</TD><TD>Value</TD><TD>Cumulative Value</TD></TR><TR><TD><P>Jan</P></TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Feb</TD><TD>1</TD><TD>3</TD><TD>4</TD></TR><TR><TD>Mar</TD><TD>1</TD><TD>5</TD><TD>9</TD></TR><TR><TD>Jan</TD><TD>2</TD><TD>7</TD><TD>7</TD></TR><TR><TD>Feb</TD><TD>2</TD><TD>11</TD><TD>18</TD></TR><TR><TD>Mar</TD><TD>2</TD><TD>13</TD><TD>31</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>However, when sorted by Month in table view (which is also the only sort available for a line char with date on the x-axis), the following happens:</P><TABLE border="1"><TBODY><TR><TD>Month</TD><TD>Tier</TD><TD>Value</TD><TD>Cumulative Value</TD></TR><TR><TD><P>Jan</P></TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Jan</TD><TD>2</TD><TD>7</TD><TD>8</TD></TR><TR><TD>Feb</TD><TD>1</TD><TD>3</TD><TD>3</TD></TR><TR><TD>Feb</TD><TD>2</TD><TD>11</TD><TD>14</TD></TR><TR><TD>Mar</TD><TD>1</TD><TD>5</TD><TD>5</TD></TR><TR><TD>Mar</TD><TD>2</TD><TD>13</TD><TD>18</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Obviously it sums the values grouping by month rather than tier. Any solutions? I'd like the cumulative values from the first table visualized in a line chart with Month on the x-axis and Tier as the dimension. Thanks.</P> Sat, 16 Nov 2024 19:41:52 GMT nmarinelli 2024-11-16T19:41:52Z Rangesum / Above in Line Chart https://community.qlik.com/t5/App-Development/Rangesum-Above-in-Line-Chart/m-p/1645489#M48123 <P>Hi all,</P><P>I'm running into trouble presenting a cumulative sum broken down by a dimension in a line chart.&nbsp;</P><P>I would like the following for "Cumulative Value". My current formula is rangesum(above(sum(Value), 0,3)), and it works in table form when you sort by Tier, and in the line chart when the primary dimension is Tier and the secondary is Month.</P><TABLE border="1"><TBODY><TR><TD>Month</TD><TD>Tier</TD><TD>Value</TD><TD>Cumulative Value</TD></TR><TR><TD><P>Jan</P></TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Feb</TD><TD>1</TD><TD>3</TD><TD>4</TD></TR><TR><TD>Mar</TD><TD>1</TD><TD>5</TD><TD>9</TD></TR><TR><TD>Jan</TD><TD>2</TD><TD>7</TD><TD>7</TD></TR><TR><TD>Feb</TD><TD>2</TD><TD>11</TD><TD>18</TD></TR><TR><TD>Mar</TD><TD>2</TD><TD>13</TD><TD>31</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>However, when sorted by Month in table view (which is also the only sort available for a line char with date on the x-axis), the following happens:</P><TABLE border="1"><TBODY><TR><TD>Month</TD><TD>Tier</TD><TD>Value</TD><TD>Cumulative Value</TD></TR><TR><TD><P>Jan</P></TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Jan</TD><TD>2</TD><TD>7</TD><TD>8</TD></TR><TR><TD>Feb</TD><TD>1</TD><TD>3</TD><TD>3</TD></TR><TR><TD>Feb</TD><TD>2</TD><TD>11</TD><TD>14</TD></TR><TR><TD>Mar</TD><TD>1</TD><TD>5</TD><TD>5</TD></TR><TR><TD>Mar</TD><TD>2</TD><TD>13</TD><TD>18</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Obviously it sums the values grouping by month rather than tier. Any solutions? I'd like the cumulative values from the first table visualized in a line chart with Month on the x-axis and Tier as the dimension. Thanks.</P> Sat, 16 Nov 2024 19:41:52 GMT https://community.qlik.com/t5/App-Development/Rangesum-Above-in-Line-Chart/m-p/1645489#M48123 nmarinelli 2024-11-16T19:41:52Z Re: Rangesum / Above in Line Chart https://community.qlik.com/t5/App-Development/Rangesum-Above-in-Line-Chart/m-p/1645497#M48124 <P>Try this</P><LI-CODE lang="markup">Aggr( RangeSum(Above(Sum(Value), 0, 3)) , Tier, Month)</LI-CODE> Mon, 11 Nov 2019 16:49:25 GMT https://community.qlik.com/t5/App-Development/Rangesum-Above-in-Line-Chart/m-p/1645497#M48124 sunny_talwar 2019-11-11T16:49:25Z