Qlik Community

New to Qlik Sense

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

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
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
Specialist II
Specialist II

Kees1
Contributor II
Contributor II
Author

Hi Anat,

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

AG-gugelbisolutions

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!

Henric_Cronström

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...