topic Re: Rank function not working properly in QlikView

Rank function not working properly

sannidhikumar — Fri, 16 Dec 2016 11:02:23 GMT

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 — Fri, 16 Dec 2016 12:24:16 GMT

What exact issue you are running into?

marcus_sommer — Fri, 16 Dec 2016 14:20:26 GMT

Maybe this:

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

- Marcus

swuehl — Fri, 16 Dec 2016 14:25:11 GMT

=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 — Mon, 19 Dec 2016 06:55:38 GMT

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 — Mon, 19 Dec 2016 11:20:26 GMT

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?