Can List Box display lists be controlled

[bimala0507]

Dear experts:

Is there a way, I can control the list of values in list box.

E.g: I have a list of Item1.... Item10 values against a dimension and based on certain condition I would like to show only 5. Can it be achievable ?

Kind Regards,

Bimala

[alexandros17]

At the end of list of fields there is an item "Expression", write there the condition to show items, ex.: If(myCond, myField, Null())

let me know

[tresB]

Expression like:

If(Field='Value1' or Field= 'Value2', Field)

Or,

If(Match(Field,'Value1' , 'Value2'), Field)

[bimala0507]

Hi:

I tried that. It just shows the expression value as null() against the item, but I want the list item should be excluded if the condition satisfies.

Kind Regards,

Bimala

[tresB]

Just an extra Not would do the job. Try like:

If( Not myCond, myField)

[bimala0507]

Hi:

Appreciate, if an example can be given.

Kind Regards,

Bimala

[arulsettu]

try this in list box expression

field - your field

if(match(field,'1','2','3','4','5'),field)

[tresB]

I am in hunt of appreciations. . PFA

[bimala0507]

Hi Tresesco:

Thank you so much for your assistance. But my requirement is little different. I want to control the display of field1, by checking the field2 .

E.g. field1 field 2

        'xxxx'    1

        'yyyy'      1

        'zzzz'      0

I would like to give a condition that if (field2=1) , than display all those field1 which satisfies the condition.

Attached the qvw file for your reference.

Kind Regards,

Bimala

[anbu1984]

Try this expression

=If([field2]=1,field1)