Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
in the field list use the last item "Expression" and write:
If(left(myField, 5)='Box 3', myField, Null())
let me know
Use an expression like this one:
If(WildMatch(FieldName, 'Box 3*'), FieldName)
in many ways :
load
if(left(yourfield, 4)='Box 3', yourfield) as yourfield
or
by using wildmatch:
if(wildmatch(yourfield etc.
Instead of selecting a field select "expression" on the list of fields and put in this expression:
If( myField Like 'Box 3*' , myField )
Hi,
Please see the below:
Hope this helps
Hi,
You can create an expression like:
if(left(SubField(Field,'Box ',2),1)='3',Field)
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
Actually I got it.
Thanks it worked!
~Norman Rea