Filtering Strings

[#1]

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

[alexandros17]

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

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

let me know

[sunny_talwar]

Use an expression like this one:

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

[giakoum]

in many ways :

load

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

or

by using wildmatch:

if(wildmatch(yourfield etc.

[petter]

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

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

[sinanozdemir · Accepted solution]

Hi,

Please see the below:

Hope this helps

[fvelascog72]

Hi,

You can create an expression like:

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

[#8]

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

[#9]

Actually I got it.

Thanks it worked!

~Norman Rea