15 Replies Latest reply: May 31, 2018 1:14 PM by Matt Milian RSS

    Need bottom 20 results

    Matt Milian

      I have an expression:

       

      Sum([Net Cash])

       

      I need to only show the lowest 20 results of this expression in a table based on the dimension [ID].  I tried this expression, but it brought in the lowest 20 IDs.  I want it to sort by ID based on the 20 lowest Net Cash values.

       

      if(aggr(rank(Sum([Net Cash])),[ID])<=20,[ID])

       

      Qlik Forums Bottom 20.GIF