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?

       

      2015-02-28_0222.png