topic Re: Using Match/Wild match to select fields from 100-300 in QlikView

Using Match/Wild match to select fields from 100-300

markgraham123 — Wed, 15 Jul 2015 13:39:30 GMT

Hi,

I'm trying to select only the points which are from 100-300 using Match in where condition.

Where

(Branch='ABC' and Match(Points, ' ')

Can anyone help pls.

Re: Using Match/Wild match to select fields from 100-300

sunny_talwar — Wed, 15 Jul 2015 13:46:19 GMT

Not sure I understand Mark, would you be able to elaborate?

Re: Using Match/Wild match to select fields from 100-300

markgraham123 — Wed, 15 Jul 2015 13:48:23 GMT

Hi Sunny,

I wanna select the values from the field "Point".

It should be of the range 100-300 for Branch 'ABC'

So, i'm trying to use the below code. But not able to specify range ....

Where

(Branch='ABC' and Match(Points, ' ')

Re: Using Match/Wild match to select fields from 100-300

marcus_sommer — Wed, 15 Jul 2015 13:54:09 GMT

You mean something like this?

Where

Branch='ABC' and Points >= 100 and Points < 300

- Marcus

Re: Using Match/Wild match to select fields from 100-300

Gysbert_Wassenaar — Wed, 15 Jul 2015 13:56:39 GMT

Like this:

Where

(Branch='ABC' and Points >= 100 and Points <= 300)

Re: Using Match/Wild match to select fields from 100-300

markgraham123 — Wed, 15 Jul 2015 13:58:47 GMT

Hi,

I was trying to know is there any way to use Interval match or any other function other than using Greater than and less than symbols.

Re: Using Match/Wild match to select fields from 100-300

markgraham123 — Wed, 15 Jul 2015 13:59:04 GMT

Hi,

I was trying to know is there any way to use Interval match or any other function other than using Greater than and less than symbols.

Re: Using Match/Wild match to select fields from 100-300

marcus_sommer — Wed, 15 Jul 2015 14:03:21 GMT

You could use match(Points, 100,101,102, ...) or instead of match a mapping and applymap() or you could use a join-table as filter but what speaks against >= and <=?

- Marcus

Re: Using Match/Wild match to select fields from 100-300

jonathandienst — Wed, 15 Jul 2015 14:52:15 GMT

To use Match you would have to list all the possible symbols in the range 100 - 300, so I think the previous suggestions will work better, although you could use

Where WildMatch(Points, '1??', '2??', '3??') as a condition

This will allow things like 1XY as well as numbers...

Re: Using Match/Wild match to select fields from 100-300

marcus_sommer — Wed, 15 Jul 2015 15:02:41 GMT

Yea an interessting approach but shouldn't it be: WildMatch(Points, '1??', '2??', '300').

- Marcus

Re: Using Match/Wild match to select fields from 100-300

markgraham123 — Wed, 15 Jul 2015 20:04:34 GMT

Thanq Marcus

Re: Using Match/Wild match to select fields from 100-300

markgraham123 — Wed, 15 Jul 2015 20:04:45 GMT

Thanq Gysbert