1 Reply Latest reply: Jun 17, 2010 8:23 PM by John Witherspoon RSS

    How to Rank of Entire Group After Selection?

      I have the following chart in qlikview:

       

       

      Client Revenue RevRank

      a 4 1
      b 3 2
      c 2 3
      d 1 4

      but when I click on client 'd' for example, I get:

      Client Revenue RevRank

      d 1 1

      How can I edit my expression to make it so that when I click on 'd', I still get the overall RevRank:

      Client Revenue RevRank

      d 1 4

       

      my current expression is: rank(sum(Sales))