How to display top 'x' client sales in a bar chart using a slider

[regowins]

I have a stacked bar chart where I have too many client sales listed by year. I want to give the user the ability to limit the bar chart to the top 5,10, 15..x  clients by year using a slider. For example, if I pick 5 on the slider then chart should show me the top five clients for each year. If I pick 10, the chart should show top 10 clients for each year.  This is similar to what the dimension limit option does but more dynamic.

Thanks for the help!

[#2 · Accepted solution]

For your desired dimension, use the dimension limits option (QV11) to show only Largest, but use a varialbe name for the value specification, i.e., $(vTopN).  Then setup your slider to use this same variable (vTopN).

[neha_shirsath]

Hii Ashwin,

Please see the attached qvw,Hope it will help you.

Regards,

Neha

[regowins]

Thank you, both your answers were very helpful!!