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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Kees1
Contributor II
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?

 

Thanks in advance!

Labels (3)
1 Solution

Accepted Solutions
Kees1
Contributor II
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!

View solution in original post

6 Replies
anat
Master
Master

Kees1
Contributor II
Contributor II
Author

Hi Anat,

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

AG-gugelbisolutions
Creator II
Creator II

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.

Kees1
Contributor II
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!

Kees1
Contributor II
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!

hic
Former Employee
Former 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...