List box value filtering

[raju_salmon]

Dear Experts,

I have a list box contain some names, whereas i want to show only few selected names.

Ex:

Name

ABC

XYZ

STR

VWX

SDR

I want to show display a list box without XYZ and SDR, is there any way like writing a expression on sort tab or any other way.

Please suggest.

Regards,

Raju Salmon

[#2]

u can write an expression in the list box

if(name<>'XYZ',if(name<>'SDR'),name)

Thanks and Regards

Khushboo

[#3 · Accepted solution]

For writing an expression u can go to list box properties,

on general tab field----> expression --bottom most value of list box

[maxgro]

make a listbox with the express (at the bottom)

=if(not Match(Name,'XYZ','SDR'), Name)

[#5]

use the follwing expression in List box as Expression

=if(not Match(FieldName,'Value1', 'Val2'), FieldName)

[qlikmsg4u]

Use this

=If(not Match(Name,'XYZ','SDR'),Name)