2 Replies Latest reply: Mar 2, 2015 6:47 AM by Thomas Pike RSS

    Ignore current selections within an aggr function

    Thomas Pike

      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?