topic Re: Top 10 in QlikView

Top 10

kevbrown — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 22 Sep 2017 11:28:42 GMT

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 — Fri, 22 Sep 2017 11:32:17 GMT

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 — Fri, 22 Sep 2017 11:36:03 GMT

Removing aggr seems to have worked

vkhassanov — Fri, 22 Sep 2017 11:40:12 GMT

Graph dimension:

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

Graph measure:

=sum(Won)

Gysbert_Wassenaar — Fri, 22 Sep 2017 11:42:47 GMT

kevbrown — Fri, 22 Sep 2017 11:52:27 GMT

Thank you

ravikumar_iyana — Fri, 22 Sep 2017 13:06:51 GMT

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