Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.
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'.
can you post an example set of data or a qvw?