topic Re: Using "operators" in "match function in QlikView

Using "operators" in "match function

Fri, 07 Jun 2013 04:19:27 GMT

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

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!

Re: Using "operators" in "match function

rwunderlich — Fri, 07 Jun 2013 04:23:36 GMT

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

-Rob

Re: Using "operators" in "match function

Fri, 07 Jun 2013 04:24:58 GMT

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

Re: Using "operators" in "match function

Sokkorn — Fri, 07 Jun 2013 04:36:36 GMT

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

Re: Using "operators" in "match function

Fri, 07 Jun 2013 04:41:43 GMT

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!

Re: Using "operators" in "match function

kumarnatarajan — Fri, 07 Jun 2013 05:40:41 GMT

Hi,

Try this.

Ex:

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

Find the attached file.

Re: Using "operators" in "match function

AbhijitBansode — Fri, 07 Jun 2013 06:24:05 GMT

you can filter values like below:

Re: Using "operators" in "match function

Sokkorn — Fri, 07 Jun 2013 06:44:31 GMT

Hi superida,

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

Regards,

Sokkorn

Re: Using "operators" in "match function

Fri, 07 Jun 2013 06:53:09 GMT

Thanks! Possible to give the formula for between?

Re: Using "operators" in "match function

AbhijitBansode — Fri, 07 Jun 2013 07:17:11 GMT

could be like this:

Regards,

Abhijit