topic Re: Adding fields to an alternate state listbox in QlikView

Adding fields to an alternate state listbox

Fri, 26 Sep 2014 19:02:51 GMT

Hi,

I have a simple need to implement a feature where a user can add all "possible" or "selected" fields from an inherited state list box into an inherited list box. The attached app should work like so:

Clear Group A button: clear all selections in the Group A list box.

Add to Group A button: Add all 'selected' or 'possible' values from color list box to the Group A list box. So for example if user selects 'high' from the color_popularity list, then blue and red values should be added to the Group A list box. If user selects orange from the color list box, then orange should be added to the Group A list box

Re: Adding fields to an alternate state listbox

JonnyPoole — Fri, 26 Sep 2014 20:01:53 GMT

I think i got it work. The concatenated pipe delimitted list of possible values is created in a variable which evaluates in the default state.

Then i use a 'select in field' action in state 'A' to apply the variable value.

Need to ensure the variable formula has '=' so it calculates in the default state first.

Please see attached and validate it works as you need

Re: Adding fields to an alternate state listbox

Fri, 26 Sep 2014 21:21:47 GMT

Hi,

Thanks for your solution. This solution is almost there. I should've been more precise and called it "Append to Group A" instead of "Add to Group A". I need to append any subsequent selections from color list to Group A list. So something like this in the search string of the "Add to Group A" button action:

='$(vCopy)' & '|' & GetFieldSelections(color), which obviously is not the right syntax.

and what did you mean by your note about the '=' sign. Isn't this part of the syntax? How does it relate to the state?

EDIT:

I figured out the solution. Instead of "Select in Field" you need to use "Toggle Select" for the button action.