topic Re: Define Selections for Listbox in QlikView

Define Selections for Listbox

Anonymous — Fri, 27 Feb 2015 14:00:08 GMT

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 — Fri, 27 Feb 2015 16:17:31 GMT

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 — Fri, 27 Feb 2015 16:25:17 GMT

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 — Fri, 27 Feb 2015 16:55:29 GMT

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 — Fri, 27 Feb 2015 18:31:26 GMT

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