Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to display the top 10 players for the value Mat/Inns ( Mat divided by Inns)
I tried something like this to start with but doesn't seem to work (no surprise, I'm a novice)
=if ((Mat/Inns)=max(Mat/Inns), Player)
Please help.
Thanks
Ram
In the list box under the Field use the same expression
Please see the attached QV application.
regards
Mhatim
Use = aggr(if(rank((Mat/Inn))<=10,Player),Player) instead and see the attached QV application
Regards
Mhatim
Thanks Mhatim. It did the trick when it came to chart. But I am trying to achieve this in a list box through an expression.
See attached file
In the list box under the Field use the same expression
Please see the attached QV application.
regards
Mhatim
Thanks Mhatim and gwassenaar