Top 10

[kevbrown]

I have a table that I would like to change into a bar chart of "wins" but only show the top 10 appearance makers

So I have -

Name

Appearances

Won

Lost

Drawn

So from the list of 100 people, I want the top 10 appearance makers but the graph to show the number of Wins (Won) they've had

[Gysbert_Wassenaar]

And what part are you having trouble with?

What have you already tried?

Which discussions on this have you already read, but didn't get you quite there?

[kevbrown]

The expression I have is =if(aggr(rank(sum(Won)),Appearances)<=10,Appearances)

and I've tried

=if(aggr(rank(sum(Appearances)),Won)<=10,Won)

both seem to pull out the top 7 or 8 but then 2 random names

[kevbrown]

Removing aggr seems to have worked

[vkhassanov · Accepted solution]

Graph dimension:

=if(aggr(rank(sum(Appearances)),Name)<=10,Name)

Graph measure:

=sum(Won)

[Gysbert_Wassenaar]

Perhaps this blog post helps: QlikView Blog Q-Tip #5 – Show Top Performers. Common but not too trivial. | Natural Synergies

[kevbrown]

Thank you

[ravikumar_iyana]

Hi in Chart Properties go to Dimension Limits, Click to limits then Show Only Largest 10.

Step by Step: ChartProperties>Dimension Limits>  ShowOnly: Largest, Values: 10