Define Selections for Listbox

[Anonymous]

I want to create a listbox based on the values of fields ... For example:

if([payment type]='ValueA+ValueB', 'Payment Type AB', if [payment type]='ValueC', 'ValueC'))

I havent been successful with the format above. Any suggestions?

[saurabh5]

hi David,

if you are trying to add Value A and Value B the try the below expression,

if([payment type]='ValueA'+[payment type]='ValueB', 'Payment Type AB', if [payment type]='ValueC', 'ValueC'))

try this if  it works !!!

Thanks

[Anonymous]

This didnt work. Maybe I am explaining myself wrong ...

I want this to work like an action button i have built which says

FIELD= Payment Type

SEARCH STRING=("ValueA"|"ValueB")

This way if I am summing values and displaying data it is only limited to ValueA and ValueB in the Payment Type field.

[saurabh5]

hi David,

I might have a complex way to do...

create the field ...

1......if

([payment type]='Value A' or [payment type]='Value B','Payment Type AB' ,if([payment type]='Value C','Value C' )) as

mod_type

then use this new field in action of your button.

2.....Create two list box one with payment type and other with mod_type.

3....create two variables to hide and show the list box (using conditionally hideing using the variable).

4....create one more button to with action 'clear' and showing the list box 'payment type'.

[Anonymous]

can you post an example set of data or a qvw?