Announcements
cancel
Showing results for
Did you mean:
Creator

## Line Chart Accumulation

New to Qlik Sense. I have a simple line chart. Where is the option to choose between full accumulation and no accumulation?

My expression is =SUM({\$<promoCDE={"Adult*"},}>}[Net Sold Qty])

1 Solution

Accepted Solutions
MVP

I am not sure if Qlik Sense has that option or not, but why don't you just use an expression to do it

```=RangeSum(Above(Sum({\$<promoCDE = {"Adult*"}>} [Net Sold Qty]), 0, RowNo()))

or

=RangeSum(Above(TOTAL Sum({\$<promoCDE = {"Adult*"}>} [Net Sold Qty]), 0, RowNo(TOTAL)))```
2 Replies
MVP

I am not sure if Qlik Sense has that option or not, but why don't you just use an expression to do it

```=RangeSum(Above(Sum({\$<promoCDE = {"Adult*"}>} [Net Sold Qty]), 0, RowNo()))

or

=RangeSum(Above(TOTAL Sum({\$<promoCDE = {"Adult*"}>} [Net Sold Qty]), 0, RowNo(TOTAL)))```
Specialist

from a few years ago, but how can I use the count function and accumulate? I modified your expression but its not changing the chart:

Count({\$<[Date Type]={'VPP Dates'}>} Gateways)