# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Contributor II

## Slider/Filter issue/solution

Hi Guys,

I hope someone can help me with this issue.

So, my client wants the possibility to filter. Here is the case:

We sell 'stuff' from 1 article per order, until 100,000 per order.
My client wants to filter out the small orders.

< 50
< 100
< 150
< 200
< 250

He wants to filter on order with 50 products or fewer, 100 product or less, etc.
My idea was to create a slider, so he can set ranges: 50 products per order ----- 100 products per order, so he can see al orders with a range between 50 and 100 products per order.

I can't find any material to build a slider like this.

Can someone help me with this? Or maybe you have another solution for his wish?

Labels (3)

• ### Visualization

1 Solution

Accepted Solutions
Contributor II
Author

This is the solution i have and (and it works also):

if(#Aantal <= 50 , '0-50',
if(#Aantal <= 100 , '50-100',
if(#Aantal <= 150 , '101-150',
if(#Aantal <= 200 , '151-200',
if(#Aantal <= 250 , '201-250',
'>250'
))))) as 'SmallOrderFilter';

Creating a filter with these code in the editor. Works also! Thanks everyone for helping out!

6 Replies
Specialist II
Contributor II
Author

Hi Anat,

Thanks for your reply. But this solution does not work for me/my client.

Creator

Unfortunately, there is no standard "double" slider, even though @anat solution goes pretty close to that.

I suppose you can calculate the number of items per order at script time, for the sake of semplicity. Let's say the calculated field is [# of Items]. Provided that, another possible solution is to create two inputboxes and a button that gets activated if the inputboxes contain numerical values and the first is lower than the second, for example; if the user clicks on the button, you apply a selection to [# of Items].

Hope it helps.

Contributor II
Author

This is the solution i have and (and it works also):

if(#Aantal <= 50 , '0-50',
if(#Aantal <= 100 , '50-100',
if(#Aantal <= 150 , '101-150',
if(#Aantal <= 200 , '151-200',
if(#Aantal <= 250 , '201-250',
'>250'
))))) as 'SmallOrderFilter';

Creating a filter with these code in the editor. Works also! Thanks everyone for helping out!

Contributor II
Author

This is the solution i have and (and it works also):

if(#Aantal <= 50 , '0-50',
if(#Aantal <= 100 , '50-100',
if(#Aantal <= 150 , '101-150',
if(#Aantal <= 200 , '151-200',
if(#Aantal <= 250 , '201-250',
'>250'
))))) as 'SmallOrderFilter';

Creating a filter with these code in the editor. Works also! Thanks everyone for helping out!

Employee

Try putting

=Aggr(Ceil(Count(article),50),Order)

in a filter pane - or as a dimension in a chart.

You can make this expression more elaborate by using variables, but I am not sure that that is needed...