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)?
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.
