Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can somebody please help me on the below Scenario.
I have 5 list boxes from a single table. I have created 2 multi boxes including all the 5 list boxes in both Multi box 1 and Multi box 2.
Let us say if i select any values from list box 1 to list box 5 in Multi box 1, how to exclude all the selections from the same List boxes in Multi box 2.
Any Suggestions how to achieve this.
Thanks in Advance.
Thanks Stefan.
I will try to implement this and thanks for all your help.
You can use alternate states for that, if I understand your requirement correctly.
Selections made in one alternate state will not influence the other states.
Create the states in Settings - Document properties - Alternate states, then assign the multi boxes to separate states on General tab of the object properties.
Hi
Alternate states is a way to exclude selection in other list box
PFA sample
Thanks
You can use Alternate States to perform comparative analysis between sets of multiple data items, for example for basket analysis purposes. A state holds a set of selections.
The QlikView developer can create multiple states within a QlikView document and apply these states to specific objects within the document. Objects in a given state are not affected by user selections in the other states.
Setting Alternate States
Do the following to enable and set alternate states:
Click Alternate States... in the Document Properties: General tab.
The Alternate States dialog opens.
Click Add... to create a number of states give name to them. The names will be referred to as Alternate state identifiers.
Click OK to close the dialog.
Use these AlterState names in required multi boxes, then Selections in MultiBox1 won't effect, selections in Multibox2.
Hi Stefan,
Thanks for your reply.
Is there any other way instead of Alternate States.
Actually in my application i need to provide the user nearly 12 multi boxes and based on the selections in those multi boxes, charts and details tables needs to get updated. so can we give multiple Alternate states to a single chart?
Thanks in Advance.
Yes, you need to use set analysis in the aggregation functions of your chart expressions:
=Sum( {AlternateState1} Value)
=Sum( {AlternateState2} Value)
Hi Ritesh,
Thanks for your Reply.
How can we give multiple alternate states to a chart expression, i mean let us say i have created 12 Multi boxes and as per alternate states all selections in every multi box won't reflect any of it. As per my requirement ,there is a chart in the same sheet which needs to get reflect with each selection in every multi box.
Thanks in Advance.
Thanks Stefan.
Can we give an Expression like this:
=Sum( {AlternateState1,AlternateState2} Value)
i mean the expression should consider selections from Alternate State 1 and Alternate State 2.
Is it possible? sorry if it seems funny, i have never worked on Alternate states.
Thanks in Advance.
Set Analysis can mix several states, in several ways, for example using the union operator +
{AlternateState1 + AlternateState2}
You can modify all states using set modifiers.
I would recommend having a closer look to the possibilites of set analysis.
Thanks Stefan.
I will try to implement this and thanks for all your help.