Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to filter from a listbox, values, say between 5 to 10.
values |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
I know i probably have to drag the desired selection manually.
However, there is another function, with the formula if(match(values, 5,6,7,8,9,10), values)
values |
5 |
6 |
7 |
8 |
9 |
10 |
How can i use an operator such as <=10 and >=5 to achieve the above?
something like this:
if(match(values, between (5,10), values)
What are the functions for matching values "between", "more than" and "less than" also?
thanks!
Where do you want to do this filtering. In a Set Analysis expression? Or an Action?
-Rob
i have created a list box. this values are in listbox.
Hi superida,
May be this one you looking for.
1. Click search icon in your List Box
2. Type >=5<=10
3. Hit enter key to filter value from List Box
See sample here
Regards,
Sokkorn
Oh! great! thanks.
Sorry i have another slight variation. If i want to search for values that occur >5 times...
Values | Frequency |
1 | 1 |
2 | 2 |
3 | 1 |
4 | 5 |
5 | 5 |
6 | 5 |
7 | 10 |
8 | 5 |
9 | 5 |
10 | 5 |
I had initially aske that question as i thought match function would do the trick.
So, for listbox, with frequencies of occurence, how can i filter those with a certain frequency?
thanks!
Hi,
Try this.
Ex:
=Aggr(Sum({$<Value={">=$(=Min(Value)) <=$(=max(Value))"}>}Value),Value)
Find the attached file.
you can filter values like below:
Hi superida,
Can you share business case that you trying to filter value by frequency?
Regards,
Sokkorn
Thanks! Possible to give the formula for between?
could be like this:
Regards,
Abhijit