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.
