Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
regowins
Creator II
Creator II

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

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!

1 Solution

Accepted Solutions
Not applicable

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).

View solution in original post

3 Replies
Not applicable

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).

View solution in original post

neha_shirsath
Specialist
Specialist

Hii Ashwin,

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

Regards,

Neha

regowins
Creator II
Creator II
Author

Thank you, both your answers were very helpful!!