listbox expression

[sivarajs]

Hi,

I am trying to show few columns in listbox based on product code as key column.I am using maxstring in expression to fetch values. Because of this keyword am getting only one row out of 10 values to a single product code.Is there any keyword or any ways where i can show all the values in listbox.

Also i need to select only one row at a time.

Regards,

Sivaraj

[Gysbert_Wassenaar]

Why do you need those columns in a listbox? Can't you use a Table Box object instead? That way you won't need to mess around with expressions.

[sivarajs]

As i mentioned, the user need to select only one row at a time. In listbox we have check option, so i used  it.

[sivarajs]

gysbert, anyway to achieve this?

[Gysbert_Wassenaar]

Nope. Use a listbox for selecting, use a table box for showing the other columns.

[tresesco]

Kind of work around(with obvious limitations) could be like attached sample qvw?

[Anonymous]

Hello,

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

[Gysbert_Wassenaar]

You created the expression on the Expressions tab. Now create it instead after selecting <Expression> in the field selector on the General tab.

[Anonymous]

Thank you so much.

Regards,

Paul