alphabetical rank restricted to a set

[#1]

Hi all

I need to restrict a rank function that gives me alphabetic order to a set of rows, I can achieve this with other expressions by using set analysis but not this expression:

rank([Field 1],4)

e.g. if I have a table like:

Field 1	Field 2
A	10
B	20
C	30
D	40
E	50

I use set analysis like {<[Field 2]-={30}>}

this restricts the table correctly for other expressions but in the expression for rank as above I get 1,2,4,5, when I want 1,2,3,4....?

If anyone can help I'd really appreciate it.

Thanks

Dominic

[sunny_talwar · Accepted solution]

Seems to be working, not sure what you mean. Do you not get this output?

[maxgro]

maybe

only({$ <[Field 1]-={"=rank([Field 1],4)<=1"}>} [Field 1])

[#4]

Hi

I wasn't using Only!  I always forget that one - when you need a set and no aggregation.

Thanks

Dominic

[sunny_talwar]

where else were you using {<[Field 2]-={30}>}. Rank doesn't allow for a set expression.

So is the issue resolved now? I am confused

Best,

Sunny

[#6]

Yes, I have other expressions in the table that allow for the set expression but couldn't think how to apply the set to the rank - like I say I infrequently use the only function.  Thanks.

[sunny_talwar]

No problem. I am glad I was able to help.

Best,

Sunny