topic Re: Filtering Strings in QlikView

Filtering Strings

Tue, 16 Jun 2015 12:33:47 GMT

I have a list box that has data such as this.

Box 301

Box 302

Box 303
Box 701

Box 702

Box 310

I want it to only list the items that start with "Box 3....."

How can I do this?

~Norman Rea

Re: Filtering Strings

alexandros17 — Tue, 16 Jun 2015 12:35:51 GMT

in the field list use the last item "Expression" and write:

If(left(myField, 5)='Box 3', myField, Null())

let me know

Re: Filtering Strings

sunny_talwar — Tue, 16 Jun 2015 12:36:00 GMT

Use an expression like this one:

If(WildMatch(FieldName, 'Box 3*'), FieldName)

Re: Filtering Strings

giakoum — Tue, 16 Jun 2015 12:36:14 GMT

in many ways :

load

if(left(yourfield, 4)='Box 3', yourfield) as yourfield

by using wildmatch:

if(wildmatch(yourfield etc.

Re: Filtering Strings

petter — Tue, 16 Jun 2015 12:36:20 GMT

Instead of selecting a field select "expression" on the list of fields and put in this expression:

If( myField Like 'Box 3*' , myField )

Re: Filtering Strings

sinanozdemir — Tue, 16 Jun 2015 12:37:38 GMT

Hi,

Please see the below:

Hope this helps

Re: Filtering Strings

fvelascog72 — Tue, 16 Jun 2015 12:40:16 GMT

Hi,

You can create an expression like:

if(left(SubField(Field,'Box ',2),1)='3',Field)

Re: Filtering Strings

Tue, 16 Jun 2015 12:42:16 GMT

These are great and work. Will any of these work in Qliksense? I need it to work in both places. Can't seem to get it to work there.

~Norm

Re: Filtering Strings

Tue, 16 Jun 2015 12:43:52 GMT

Actually I got it.

Thanks it worked!

~Norman Rea