topic Re: Select multiple values based on selection 1 to many in QlikView

Select multiple values based on selection 1 to many

nam — Fri, 31 Oct 2014 19:53:10 GMT

Hi can someone help me with my scenario to create the best, quickest Method to achieve this

I have 2 fields Field A and Field B

when selecting 1 value in Field A I get many values in (White) associated in Field B

What I want to do is if I select 1 value in Field A I want the multiple values to be selected as (green) rather then associated(white).

Please share your comments or examples on how this can be achieved quickly

JonnyPoole — Fri, 31 Oct 2014 20:10:47 GMT

In the document properties go to triggers.

Under Field Event Triggers , highlight field A and add a 'on select' action.

Add an action of type Select -> Select in field

enter [Field B] for the field and the following for the search mask:

='("' & concat( distinct [Field B], '"|"') & '")'

Below you can see me doing this for a field called Country instead of [Field B]

maxgro — Fri, 31 Oct 2014 20:25:40 GMT

PFA