Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)