Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kevbrown
Creator II
Creator II

Top 10

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

1 Solution

Accepted Solutions
vkhassanov
Contributor II
Contributor II

Graph dimension:

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

Graph measure:

=sum(Won)

View solution in original post

7 Replies
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?


talk is cheap, supply exceeds demand
kevbrown
Creator II
Creator II
Author

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
Creator II
Creator II
Author

Removing aggr seems to have worked

vkhassanov
Contributor II
Contributor II

Graph dimension:

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

Graph measure:

=sum(Won)

View solution in original post

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
kevbrown
Creator II
Creator II
Author

Thank you

ravikumar_iyana
Creator
Creator

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