Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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!!