1 Reply Latest reply: Aug 18, 2014 1:02 PM by Brian Diamante RSS

    Rank - Break tie?

      Hello, I'm currently using the Rank function to get the top 1 of some values on my table. After playing with the data, somethimes i got "four #1" (appears like 1-4 in the rank position). Is there anyway to break this tie (alphabetically,decimals, etc)?

       

      thanks in advance

        • Re: Rank - Break tie?
          Brian Diamante

          This is a couple years old, but there is a format parameter to the rank function which gives you the ability to specify how you would like a tie broken.

           

          rank( expression, 0, 1) for example would take the lowest rank.

           

          See the QV reference manual on page 822 for more info.