Show # of values based on User Input in Bar Chart

[qlikwiz123]

I have three data points.

Month

Category

Sales

I want to limit the number of items being shown in a bar chart based on user input - Either using a Input box or a slider.

Let's say I have 10 values in Category, and I am using them in a bar Chart along with Month Dimension, be in Regular or Stacked, I would like to give the users an option to input how many values from 'Categories' should be shown.

In Regular Bar Chart,  If the user inputs 5 in a box or slider, there should be only 5 bars - one bar for each Category value per month.

Similarly, if I stack categories, there should be only 5 category values stacked in a bar per month.

[Marijn]

Hi @qlikwiz123 ,
An easy way to do this is to create a variable (for example vValue), and letting the value in this variable be determined by a slider or input box. Then use the variable on the 'Dimension Limits' of the chart to show only the number that's input into the variable.

Hope this helps!

Regards,

Marijn