Rank function not working properly

[sannidhikumar]

Hi All,

Rank function is not working properly can you please suggest on this.

=IF(Aggr(Rank(SUM(CollectionAmount)),CustNo1)<=$(vTopcustomer),CustNo1)

Thanks

[sunny_talwar]

What exact issue you are running into?

[marcus_sommer]

Maybe this:

=IF(Aggr(Rank(SUM(CollectionAmount))<=$(vTopcustomer),CustNo1),CustNo1)

- Marcus

[swuehl]

Or

=Aggr(If( Rank(SUM(CollectionAmount))<=$(vTopcustomer),CustNo1),CustNo1)

This could be used as a calculated dimension, for example.

If you want to use it as expression, you should chose and use an appropriate outer aggregation function.

[sannidhikumar]

hi ,

after using this expression still i am getting same problem

Example : multi line box selcting 10 displaying customer values

20 not displaying customer values

30 not displaying customer values

50 not displaying customer values

thanks ,

[swuehl]

Sorry, I don't understand this scenario you are describing.

Could you post some more details, e.g. screenshots, or better a small sample QVW?