This content has been marked as final. Show 2 replies
In Qlik Sense I'm using the following function as a measure to get a cumulative chart with two dimensions.
=aggr(rangesum(above(sum(TotalAmount), 0, rowno() )), Time.Year, [Time.Year Week])
That is working well and produces the graph shown below (I'm using some simple IF statements in the dimensions to constrain them to current/previous years and weeks to date).
Now I want to use set analysis to ignore current selections in the values. I can't figure out how to modify the function above to achieve that. Any suggestions?