Discussion board where members can get started with QlikView.
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)
Go to Solution.
In the list box under the Field use the same expression
Please see the attached QV application.
Use = aggr(if(rank((Mat/Inn))<=10,Player),Player) instead and see the attached QV application
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
Thanks Mhatim and gwassenaar