Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Graph dimension:
=if(aggr(rank(sum(Appearances)),Name)<=10,Name)
Graph measure:
=sum(Won)
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?
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
Removing aggr seems to have worked
Graph dimension:
=if(aggr(rank(sum(Appearances)),Name)<=10,Name)
Graph measure:
=sum(Won)
Perhaps this blog post helps: QlikView Blog Q-Tip #5 – Show Top Performers. Common but not too trivial. | Natural Synergies
Thank you
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