Show Only matched values in List Box using Expression

[Anonymous]

Hello Experts,

I have loaded  thousand of records using Load script. I created a List Box and it shows all the thousand distinct values as below screen

Now i want filter and display only 6511001,6511002,7511001 and 7511006.

I went  properties of list box and wrote the expression  as below

I see the matching values besides the value and rest all not matched has '-'. I want to see only match values in the list box.

Please see below the values i see as :

I want to see only Matching value and rest all should be hidden.

Appreciate your help.

Regards,

Paul

[#2]

Create the Listbox with Expression on the general tab. The Expression is last after all fields.

[Anonymous]

Thank you Dathu. It is very helpful.

Appreciate your help.

Regards,

Paul

[Anonymous]

Thank you Dattu

[MarcoWedel]

Don't use the expression tab of the listbox properties but the expression entry in the fields dropdown box.

Regards

Marco

[Anonymous]

Thank you Marco.

Regards,

Paul