Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Show # of values based on User Input in Bar Chart

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.

1 Reply
Marijn
Creator II
Creator II

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.

Marijn_0-1682081111315.png

Hope this helps!

Regards,

Marijn