Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dmelillo
Creator III
Creator III

Define Selections for Listbox

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?

4 Replies
saurabh5
Creator II
Creator II

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

dmelillo
Creator III
Creator III
Author

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
Creator II
Creator II

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'.

jsaradhi
Specialist
Specialist

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