Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
EvanBarrick
Creator
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
sunny_talwar

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)))

View solution in original post

2 Replies
sunny_talwar

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)))
ZoeM
Specialist
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)