How to display only limited values in list box?

[#1]

Hi,

I have column as list box . The values are Soaps, Clothes, Bats, Pens, 1,4342,4435,7423847,4783274283,67,9,10,11,12

How can I make available to display only Soaps, Clothes, Bats, Pens?

Thanks.

[MK_QSL · Accepted solution]

Write below expression in your list box

=IF(NOT IsNum(Value),Value)

UPDATE : Check enclosed file..

[alexandros17]

Write instead of your field the expression (you find the item menu expression at the end of the list of fields)

if(myField = 'Soaps' or myField = 'Clothes' or myField = 'Bats' or myField = 'Pens', myField, null())

hope it helps

[#4]

Thanks where I need to give is it

expression-> show-> conditional

[#5]

you can create another field like this in dm or you can write similar expression in list box but its not performance effective

load      if(isnum(TestField)=0,TestField) as TestField;

Load * inline

[

TestField

Soaps

Clothes

Bats

Pens

1

4342

4435,

7423847

];

[#6]

Thanks and that's perfect.