bar chart with a filter for selective objects

[Coloful_Black]

Hi,

I am building a bar chart showing a YoY growth. So at my Measures/Width, I put SUM(Year A sales)/SUM(Year B sales) -1, 

Bar chart shows well given by %.  But I only want to show the Top 7 's YoY growth rate by Year A sales ( descending order) rather than % 

Is there a way to achieve this? 

[Brett_Bleess · Accepted solution]

Check the following two Design Blog posts, they are one option:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684

I am sure there are others too, seem to recall some prior posts, so if you have not search Community, would recommend that too, as you may find some other possibilities that way too.  Someone else may chime in as well given my post is going to kick things back up again too.

Regards,
Brett