topic copying selections from one list box to another list box with different alternate states in QlikView

copying selections from one list box to another list box with different alternate states

Tue, 22 Oct 2013 22:25:17 GMT

Hi, I have a situation where I have 2 tabs with a similar list box. And these list boxes have different alternate states assigned. However when selections are made on one list box in one tab I want the list box in another tab to reflect those selections. Since these 2 are in different alternate states i am struggling to achieve that. Any help would be great.

Thanks,

Ram

Re: copying selections from one list box to another list box with different alternate states

bdunphy — Tue, 22 Oct 2013 22:31:39 GMT

Stephen Redmond wrote a great blog post about switching alternate states with buttons recently....

This should give you what you need.... I think

http://community.qlik.com/docs/DOC-5092

Re: copying selections from one list box to another list box with different alternate states

Tue, 22 Oct 2013 23:56:50 GMT

Hi Ramkumar;

Synchronizing Selections between States

Example:

The following expressions can be used in a single chart:

count({$} DISTINCT [Invoice Number])

count({State1} DISTINCT [Invoice Number])

count({State2} DISTINCT [Invoice Number])

There is a problem with this method; the QlikView Developer must duplicate the selections (list boxes and

multi boxes) for all three states so that the end-user can make appropriate selections for the various states. In

many situations the QlikView Developer will want to have a set of ‘common’ selections available to all

states. This will allow the end user to set the context for the various charts and then make use of specific

selections to show the differences between states. Set Analysis can be used with states to keep certain selections

consistent between states.

Example:

count({State1<Year = $::Year, Month = $::Month>} DISTINCT [Invoice Number])

count({State2<Year = $::Year, Month = $::Month>} DISTINCT [Invoice Number])

The QliKView Developer will keep the Year and Month selections in State1 and State2 synchronized

with the Year and Month selections in the default state. The QlikView Developer can add

elements to the set modifiers as necessary in order to keep even more fields consistent between states.

Re: copying selections from one list box to another list box with different alternate states

Gysbert_Wassenaar — Wed, 23 Oct 2013 05:46:28 GMT

See this video tutorial: Transfering the Intersection of Selections Using Alternate States

Re: copying selections from one list box to another list box with different alternate states

ChristofSchwarz — Fri, 07 Mar 2014 15:58:11 GMT

If I understand you right, you don't want to copy the entire alternate state into another, but just one listbox out of such? I have documented this here, scroll down, there is a section to show, by which two actions you can syncronize a field with the values of another (also across states) ... Copy Selections from one field to another

bye