topic Re: Link two list boxes with same dimension in QlikView

Link two list boxes with same dimension

Anonymous — Tue, 08 Sep 2015 15:49:40 GMT

This sounds like a silly question but I have a real application.

For one of my dimensions I want to have a static list of options to chose from. Then I want another list box that has all the remaining possible selections. This box is formatted differently (smaller font, etc) than the main listbox and would be used less frequently. Technically one should be able to make several selections in both boxes if so desired.

Problem: Making a selection in one box wipes out the selection in the other box.

Not sure if there is a solution that includes me keeping both boxes but would really like it if there was.

Re: Link two list boxes with same dimension

ramoncova06 — Tue, 08 Sep 2015 16:22:42 GMT

you can do this, though you would need to use alternate states

Is possible to use alternate States with set analysis

Re: Link two list boxes with same dimension

malini_qlikview — Tue, 08 Sep 2015 16:49:55 GMT

Hi,

This might be useful,

Alternate States

Description

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. The end-user can create copies of these objects (server objects) and then put those objects into different states.

The most important difference between Detach and Alternate States is that ALL objects in a given state will respond to user selections made in that state. Objects in a given state are not affected by user selections in the other states.

Alternate States functionality is not accessible in the load script.

Note!
Alternate States functionality is enabled by a QlikView developer and should be used with caution as it can cause great confusion with end-users as there is no automatic on-screen indication that objects or expressions are in, or reference, alternate states. It is up to the QlikView developer to provide this information to the end-user using the StateName() function.

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, and name them. The names will be referred to as state identifiers.
Click OK to close the dialog.

Now the QlikView developer can create new Alternate States from within screen objects.End-users who access QlikView documents from a QlikView Server can make use of Alternate States but cannot create Alternate States.

Assigning States to Objects

Do the following to assign a state to an object:

Open the Properties dialog and select the General tab.
Set Alternate State to the state identifier you want to use for the object.

The object will now be independent from the rest of the document in terms of selection, unless other objects are set to the same state.

There are two states that are always available; default state and inherited. The default state is the state where most QlikView usage occurs and is represented by $. The QlikView document is always in the default state. Objects can inherit states from higher level objects, such as sheets and containers. This means that states are inherited as such: Document - Sheet - Sheet Objects. The sheets and sheet objects are always in the inherited state unless overridden by the QlikView developer.

Comparing Alternate States

You can compare two states on the same object. For example, you can create a line chart to display both states of the data with the same axis by assigning a state in the expression using Set Analysis.

Example:

If you have defined the states Group1 and Group2, you can compare the average of field Adj.Close for the groups by showing these two expressions in a line chart:

Avg({[Group1]} [Adj.Close])

Avg({[Group2]} [Adj.Close])

Also you can refer the use case, http://livingqlikview.com/alternate-states-use-cases/

Re: Link two list boxes with same dimension

Anonymous — Tue, 08 Sep 2015 18:53:22 GMT

Can you provide an example of how this might look? Do I need two alternate states or just one. I'm looking for two separate list boxes of the same dimension to feed a graph.

Re: Link two list boxes with same dimension

MarcoWedel — Tue, 08 Sep 2015 19:18:55 GMT

‌if you perform selections in a field there are per definition no "remaining possible selections".

regards

Marco

Re: Link two list boxes with same dimension

Anonymous — Tue, 08 Sep 2015 19:23:53 GMT

Please see attached -> "Product grouping tab"

Re: Alternate States example app

Re: Link two list boxes with same dimension

Anonymous — Tue, 08 Sep 2015 19:24:54 GMT

'm using an expression in the list box. I created a list box that references only specific fields within a dimension. The other list box specifically references all the others. I

List Box 1

=If(match(Scenario,vCurLBEScenario, vPrevLBEScenario, 'Actual', 'Plan', 'Standard'),Scenario)

List Box 2

=If(Not Match(Scenario,vCurLBEScenario, vPrevLBEScenario, 'Actual', 'Plan', 'Standard','CurLBE vs PrevLBE','Actual vs PrevLBE'),Scenario)

I want both list boxes to control a graph.

I think I need one alternate state and use that in List Box2. Then reference that state in the graph. Just not sure about the syntax.

Re: Link two list boxes with same dimension

Anonymous — Tue, 08 Sep 2015 19:32:01 GMT

Hi Mark,

please apply states in expressions for graph like below:

sum({[State A]<[Region] = $::[Region]>} Sales)

sum({[State B]<[Region] = $::[Region]>} Sales)

Regards

Neetha

Re: Link two list boxes with same dimension

Anonymous — Tue, 08 Sep 2015 19:36:50 GMT

Is there syntax that you could combine the expression into one telling the graph to use both states?

So in otherwords I want it to combine selections from both listbox 1 and listbox 2 into one big selection (as if I only had one list box).

Re: Link two list boxes with same dimension

Anonymous — Tue, 08 Sep 2015 19:53:33 GMT

Hi Mark,

No it's not possible to apply two different states for one Object.

For Achieving such kind of requirement , you should create 2 objects with two different states

and apply these states to expressions in graphs then only it is possible.

Regards

Neetha

Re: Link two list boxes with same dimension

ramoncova06 — Tue, 08 Sep 2015 20:50:05 GMT

yes you could, though you might need to create another state, it really depends in what you want

Re: Link two list boxes with same dimension

Anonymous — Tue, 08 Sep 2015 20:56:45 GMT

I think I have been approaching this problem from the wrong angle.

I'm going to try and create variables related to the fields I always want available and link them to buttons with triggers to select those fields. Then, create a list box of all the other possible fields you can choose if so desired.

Re: Link two list boxes with same dimension

ramoncova06 — Tue, 08 Sep 2015 21:10:59 GMT

I personally try to avoid triggers if possible, it can become very cumbersome, but alternate states can probably be as complex or more

Re: Link two list boxes with same dimension

MarcoWedel — Tue, 08 Sep 2015 21:13:16 GMT

Hi,

maybe one solution could be:

hope this helps

regards

Marco

Re: Link two list boxes with same dimension

Anonymous — Tue, 08 Sep 2015 21:16:10 GMT

Winner Winner Chicken Dinner!!

Re: Link two list boxes with same dimension

ramoncova06 — Tue, 08 Sep 2015 21:23:20 GMT

just realized that the example I uploaded was not working right

Re: Link two list boxes with same dimension

MarcoWedel — Tue, 08 Sep 2015 21:31:14 GMT

Glad you liked it.

Please close your thread if your question is answered.

Thanks

Regards

Marco

Re: Link two list boxes with same dimension

Anonymous — Tue, 08 Sep 2015 22:11:54 GMT

This was really close but it requires that both states have a selection. I need it to accept either/or or both. I suspect that is not possible given what i have learned. Thank you everyone for providing all the great (and quick) feedback. This site is very helpful. Thanks again.