Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate state and list box

Hi there,

Is there any way that when I select Item in the List Box 1 (alternate state A)

will automatically be selected in List Box 2 (alternate state B)

* the same item (selection).

Thanks,

4 Replies
jerem1234
Specialist II
Specialist II

Yes see attached example. You can add a trigger in document properties on the Trigger Tab for the field you want. Field ->On Select and/or Field-> OnChange. Then add the trigger Copy State Contents with Source state (maybe $) to target state (maybe State1). Then the selection of Listbox 1 should automatically set the listbox in the alternate state.

Hope this helps!

Not applicable
Author

Use a Field Event Trigger ('On Change' type) on the field of list box 1 with a Select in Field on field of list box 2.

regards

Not applicable
Author

QV_Help2.jpgHi there,

I still have some problems with this. Not sure what should be in "Source State" field and "Target State" field. Also what about "Alternate State" field?

My List Boxes fields are:

Cost Centre A (alternate state A)

Cost Centre B (alternate state B)

Please see attached picture:

jerem1234
Specialist II
Specialist II

Well Source would be your Alternate State A, the Target would be B (Check my example qvw, I use the default state ($) as source, and State1 for the target). The Alternate State box won't do anything in this instance.

This action however will copy the entire contents of your first state into your target state, not just one selection. If this is okay, then this will work.

If you just want one field to transfer to your B state, then you could use the trigger Select in Field instead, with Alternate State switched to state B and:

Field: [Cost Centre]

Search String: ='(' & GetFieldSelections([Cost Centre], '|') & ')'

Note, however with GetFieldSelections, it will only list out only about 8 or so selections. So you may need to put a number that's greater than the number of values you will select like:

='(' & GetFieldSelections([Cost Centre], '|', 100) & ')'

Hope this helps!