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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using "operators" in "match function

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!

9 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Where do you want to do this filtering. In a Set Analysis expression? Or an Action?

-Rob

Not applicable
Author

i have created a list box.  this values are in listbox.

Sokkorn
Master
Master

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

Untitled.png

Regards,

Sokkorn

Not applicable
Author

Oh! great! thanks. 

Sorry i have another slight variation.  If i want to search for values that occur >5 times...

ValuesFrequency
11
22
31
45
55
65
710
85
95
105

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!

kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi,

Try this.

Ex:

=Aggr(Sum({$<Value={">=$(=Min(Value)) <=$(=max(Value))"}>}Value),Value)

Find the attached file.

AbhijitBansode
Specialist
Specialist

you can filter values like below:

Filter.png

Sokkorn
Master
Master

Hi superida,

Can you share business case that you trying to filter value by frequency?

Regards,

Sokkorn

Not applicable
Author

Thanks!  Possible to give the formula for between?

Filter.png

AbhijitBansode
Specialist
Specialist

could be like this:

Filter.png

Regards,

Abhijit