Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!
https://community.qlik.com/t5/New-to-Qlik-Sense/Range-Slider-filter-in-QlikSense/td-p/1587930
try distribution graph.
Hi Anat,
Thanks for your reply. But this solution does not work for me/my client.
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.
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!
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!
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...