Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

markgraham123
Valued Contributor

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

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

Like this:

Where

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


talk is cheap, supply exceeds demand
11 Replies

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

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

markgraham123
Valued Contributor

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

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, ' ')

MVP & Luminary
MVP & Luminary

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

You mean something like this?

Where

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

- Marcus

MVP & Luminary
MVP & Luminary

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

Like this:

Where

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


talk is cheap, supply exceeds demand
markgraham123
Valued Contributor

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

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.

markgraham123
Valued Contributor

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

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.

MVP & Luminary
MVP & Luminary

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

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

MVP
MVP

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

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...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP & Luminary
MVP & Luminary

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

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

- Marcus

Community Browser