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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Can anyone help

I'm trying to add a cumulative total to my pivot table, it's nearly working...I just need a slight amendment to the code that I can't quite figure out.

I've attached a QVW which shows the table, the expression Cumulative is what I need to amend. It's currently adding up the current months data to the month before, which isn't quite right.

I need it to add the current months data to the total from the start of the year to that point.

Can anyone help?

1 Reply
whiteline
Master II
Master II

This expression is independent from [Members] label:

=Rangesum(before(sum({<stagingyear={'2013'}>}[AE Members]),0,ColumnNo()))